on 05-10-2011 11:33 PM
I have been developing in VS2010 using SAP Crystal Reports 2008. I installed Crystal Reports for VS2010 and have been developing using this. Just recently I loaded an earlier project and it asked if I wanted to upgrade to the more recent version of Crystal Reports and I said yes. However the Crystal Report Viewer now fails to display the report, it comes back with "Failed To Load Database Information". If I try and load the rpt file into Crystal within VS2010 I get the same error message but with the extended information that the crdb_xml.dll database connector could not be loaded. The report was developed within SAP Crystal Reports 2008 and use XML file as the datasource.
I assume the CR for VS2010 installs into C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86 directory and I can confirm that the crdb_xml.dll is missing.
While the C:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\win32_x86 directory which I assume is the directory for SAP Crystal Reports 2008 does contain the crdb_xml.dll file.
If my assumptions as to the problem are correct, that is, the Crystal Reports for VS 2010 does not have the crdb_xml.dll installed, where can I obtain the correct version of this DLL?
In a nut shell, you can not... kind of... see below:
CRDB_XML.dll was not meant to be used with VS .NET and thus none of the versions of CR that bundled with .NET (CR 9.1, 10.2 and 10.5) included crdb_xml.dll. Continuing with that same process, the crdb_xml.dll is not included with CRVS2010. Crdb_xml.dll was intended to only be used with the CR SDK for Java and only "full" versions (e.g.; CR v. 11.x, 12.x, etc.) of Crystal Reports include crdb_xml.dll.
Your options are:
1) Not tested, not supported; Obtain Crystal Reports 2011. This is a full, stand-alone version of CR and will include crdb_xml.dll. Copy the dll into the CRVS2010 bin directory (C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86). Keep your fingers crossed and see if that app works. Note that this will most certaily not work with the dll from CR 2008 (12.x).
2) Convert your report sot use crdb_adoplus.dll. In the designer you will see ADO .NET (XML.
Ludek
Follow us on Twitter http://twitter.com/SAPCRNetSup
Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Purchased the new full SAP Crystal Reports 2011, installed and then copied the crdb_xml.dll across. This solved the issue.
Cheers
Steve Wark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Steve
That is good news. Remember this may not be a supported scenario, but I'll ping Program Management and ask. Couple of things you will have to keep in mind from here on;
1) You will need to ensure that somehow, that dll is installed when you deploy the app. E.g.; neither the MSM nor the MSI for crcvs2010 includes the crdb_xml.dll
2) The crdb_xml.dll depends on the Java framework. See the blog [How to deploy Crystal Reports 2008 runtime for .NET when the report is connecting to XML files|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13732] [original link is broken] [original link is broken] [original link is broken];.
The blog was written specifically for CR 2008 and I am not sure if the same version of Java will work with version 2011 of the crdb_xml.dll, but I'll ask PM also.
- Ludek
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.