Error Running Report which Access 2 Databases

[gavinjb]

I have a report which connects through RDO (ODBC) to 2 databases, 1 is an Progress Database the other is an access 2000 Database. At times when I run the report I get the following error message:

Query engine Error: 'HY000:[DataDirect-Technologies][ODBC Progress Driver][Progress]Cursor not opeened (7511)'

I have onlty had this error since I have tried to connect the two databases together, when running reports just of out progress database, we have no problem.

Gavin,

 

[synapsevampire]

Hard to say why this is occuring, but rather than join the tables within the inferior database engine in Crystal, link (not import) the Progress tables in Access and create a Access query for your report to use.

Make sure you tun on the Options->Views in Crystal to expose Access QUeries.

-k