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

Failed to retrieve data from database - DataDirect Paradox

40 Views

Crystal Reports 12.1.0.892

Windows XP SP3

DataDirect ODBC Driver for Paradox 5.30.00.23

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 http://188.grandtheater.org/sql.log

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

TIA