Skip to Content
0
Former Member
May 06, 2010 at 01:31 AM

Crystal Reports 2008 - C-ISAM/ODBC Error 42000 Failed to retrieve data

511 Views

I'm hoping someone out there has a solution to this problem.

I have a bunch of reports which I've converted from CR8.5 to CR2008 (SP2 + HotFixPack 2.7 Installed)

Our server is currently running SCO UNIX OpenServer 5.0.7 with a C-ISAM Database serving our accounting software.

Some of the more basic reports have converted with no problem (daily sales figures etc...), but some reports such as customised purchase orders, and complex sales histories etc... continue to have this problem.

Note, all my reports functioned perfectly under CR8.5.

This error occurs within seconds of executing the report.

FAILED TO RETRIEVE DATA FROM THE DATABASE

Details: 42000:ERROR Syntax Error - Database Vendor Code: -1

After which, the winsock comms need to be reset.

One example SQL query is as follows (on a report re-designing my purchase order for imported products.

SELECT purchase_order.po_order_no, purchase_order_line.stock_code, purchase_order.po_backorder_flag,
purchase_order_line.po_line_description, stock_master.stk_desc_line_3, stock_master.stk_description,
stock_master.stk_desc_line_2
 FROM   (purchase_order_line purchase_order_line INNER JOIN purchase_order purchase_order ON 
(purchase_order_line.po_order_no=purchase_order.po_order_no) AND (purchase_order_line.po_backorder_flag=purchase_order.po_backorder_flag)) 
   INNER JOIN stock_master stock_master ON purchase_order_line.stock_code=stock_master.stock_code

Does anyone have any idea??? Really driving me insane... Is it the order of my links, type of links, grouping??????

Strangely, some other similarly linked reports work perfectly.

Cheers in advance,

Steve