Crystal Reports 10 - CR ODBC XML Driver 4.20 runtime installation

[Former Member]

I followed the instructions in SAP Note 1217235 - Runtime file requirements for Crystal Reports 10 XML ODBC driver (Crxml19.dll) to build a setup package for my application with the ODBC XML Driver, but when I have installed the setup I get the following error in Microsoft ODBC Administrator when trying to use the driver:

The setup routines for the CR ODBC XML Driver 4.20 ODBC Driver could not be loaded due to system error code 126.

This is followed by the error:

Could not Load the setup or translator library - with the messagebox title of Drivers' ConfigDSN, ConfigDriver, or ConfigTranslator failed.

On my development machine the driver shows up in the list of ODBC drivers with the versions, company and date columns filled in properly, On the target installation the verison and company columns show "not marked" and the date is blank.

Of course this all works on my development machine which was upgraded from earlier versions of Crystal Reports to version 10.

The only thing different about my development machine is that the article lists the licence file as lvcr.lic and the one I have is qecr.lic. I found another article that explained that depending on the version of version of crdb_odbc.dll, you use one or the other. The earlier version looks for qecr.lic, but both versions mentioned were version 9.x. My version of crdb_odbc.dll is version 10.0.5.768

I have used depends.exe to point our any missing dependancies, but the only one it finds is with GDIPLUS.DLL which is present on my target computer in a newer version. Depends.exe shows the same error on my development computer where the XML ODBC driver works.

I've run out of ideas - Please help !!

[former_member183750 · Accepted solution]

I do not have anything specific to CR 10 and CR 10 being out of support for a long time, it's hard / impossible to get much info on this. However, I do have information on deployment of CRDB_XML.dll driver that ships with CR 2008. Perhaps the ideas presented in [this|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13732] [original link is broken] [original link is broken] [original link is broken]; blog will be of some use. The instructions in the blog would have to be adjusted for CR 10 (e.g.; bin locations, etc.).

Ludek

[Former Member · Accepted solution]

Where do I find this blog on CRDB_XML.dll from CR 2008?

[Former Member · Accepted solution]

Found the link to the blog in the email. I expected it to be in the thread. However, this is a completely different driver that is based on and requires the Java Run Time, so it is not of any help. Thanks for trying.

[Former Member · Accepted solution]

Here is an update to the problem.

I tried using the setup for Crystal Reports 10 to install the ODBC XML driver on the target computer where my setup had failed to install the driver correctly. I unchecked the default options and checked only the ODBC XML Driver. The setup throws the same error about the setup/translation library that the ODBC configuration does.

Then I tried installing Crystal Reports 10 with most of the (default) options of other drivers selected and this time it worked. So my conclusion is that there is some dependancy for the driver setup that must be a common dll for all the DataDirect drivers or something like that.

The help in CR 10 gives runtime requirements for the ODBC XML driver, but lists an older driver from Merant and the file names contain 17, not 19 liike the DataDirect driver. The original version of the setup for this program installed an intermediate version of the driver with 18 in the filename. I think the version of CR at the time was 8.5. Unfortunately the setup used was not the setup and deployment wizard from VB6 so I can't dig into it to see what they did for the ODBC driver.

The program I am deploying is an old VB6 program I inherited, so I don't think the ADO XML route is an option.

I can't go around installing CR10 on every target computer for the program. It's OK this one time because I am moving my development environment from the old computer to a new one and have to install VB6 and CR10 on the new computer anyway, but for a runtime only environment I am stumped.

[former_member183750 · Accepted solution]

Unless someone that remembers this from CR 10 pipes in, only other suggestion I have is to upgrade to a supported version of Crystal Reports. In your case as you are using the RDC and VB 6, that would be CR XI release 2 as the RDC has been retired in CR 2008.

Ludek