Skip to Content
Former Member
Dec 17, 2008 at 10:00 PM

Failed to retrieve data from database - DataDirect Paradox


Crystal Reports

Windows XP SP3

DataDirect ODBC Driver for Paradox

Paradox 5 database

When I run the following query against two tables:

SELECT `Ticket1a`.`PatronID`, `PHONELIN`.`PhoneNumber`

FROM `PHONELIN` `PHONELIN` INNER JOIN `Ticket1a` `Ticket1a` ON `PHONELIN`.`PatronID`=`Ticket1a`.`PatronID`

I get the following error:

Failed to retrieve data from the database

Details: 42000: DataDirect ODBC Paradox driver Extra characters at end of query: INNER. Database VendorCode: 3902

The SQL tracing log can be found at

Can anyone tell me what is going on here and how I can get around it?