Intermittent 'Unknown Database Connector' Error with Crystal XI in VFP9 app

[Former Member]

We have a VFP9 application which uses Crystal XI as its reporting tool. We use Installshield Express to install the Crystal components by including the merge modules in the setup.

We extract data in the VFP app then write it to the local temporary files folder on the PC running the app. The VFP app then opens the crystal report and changes the database locations (xbase files). We intermittently get an OLE IDispatch exception with Crystal error u201CUnknown Database Connectoru201D. If the user runs exactly the same process again it is likely to be OK. The system had been relatively stable and unfortunately we cannot pinpoint what changed to introduce this problem. Around the same time we did install a new server, upgrade PCs to dual processor and also upgrade to Crystal XI!

If anyone has had a similar problem or has any idea what the problem could be please let me know as our users are becoming frustrated with the system crashes they are encountering.

[former_member183750 · Accepted solution]

First thing to do is to make sure you have the latest Service Pack. You mention that you are using CR XI, but I don't know if it is CR XI r1 or CR XI r2. Assuming it is r1, the latest SP is here:

https://smpdl.sap-ag.de/~sapidp/012002523100006008952008E/crXIwin_sp4.zip

If you are using CR XI r2, the latest SP is here:

https://smpdl.sap-ag.de/~sapidp/012002523100006255422008E/crxir2_sp4_inc.exe

You will also have to create a new deployment project. MSM for cr xi r1 is here:

http://resources.businessobjects.com/support/communityCS/FilesAndUpdates/crXI_rdc_merge_modules.zip

and for CR XI r2 is here:

https://smpdl.sap-ag.de/~sapidp/012002523100009381702008E/crxir2sp4_rdc_mm.zip

Next, you mention that this is an app upgraded to CR XI, but you do not mention the version of CR you upgraded from. If it is from CR 8.5 or older, we may want to take a look at the code you are using to connect to the database. E.g.; sending the database code used my be a good idea.

Finally, please note that the platforms.txt does not mention VFP as a supported platform. E.g.; VFP was not tested and thus if there are any issues with the RDC, these will have to be duplicated on a supported platform before being submitted for a fix. Also, just for your information, the RDC has been retired in the currently shipping CR 2008.

Ludek

Edited by: Ludek Uher on Oct 2, 2008 3:31 PM