Failed to retrieve data from the database [Database Vendor Code: -1101

[Paul2u]

I have created a Crystal Report connecting to an Informix Database. This report was developed using Visual Studio 2010. This Report AUTO Refreshes Every minute. Sometimes the report will stay running for hours and somtimes it will begin to generate the following error "Failed to retrieve data from the database [Database Vendor Code -11017]. Does anyone know what could be wrong??? Here is a copy of the SQL

" SELECT route.rte_no, route.total_shipments, route.total_weight, route.total_feet, route.pull_time, route.rte_status, trlposition.cur_dock_door[1,4] cur_dock_door, trlposition.trailer_no, Cur_Load_No
FROM windb:informix.route route, OUTER windb:informix.trlposition trlposition
WHERE (route.rte_no=trlposition.route) and route.rte_status <> 'C'
ORDER BY route.rte_no"

 

[hilfy]

Have you looked up the error code -11017 in the Informix documentation? That would be where I would start as it might give you more information about what's going on.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.