The database DLL 'crdb_b1.dll' could not be loaded

[silambarasan_rajendran]

Hi Friends,

         I am trying to export the Crystal report by using the following source.

             Dim CrExportOptions As ExportOptions

            Dim CrDiskFileDestinationOptions As New _

            DiskFileDestinationOptions()

            Dim CrFormatTypeOptions As New PdfRtfWordFormatOptions()

            CrDiskFileDestinationOptions.DiskFileName = "Test"

            CrExportOptions = docreport.ExportOptions

            With CrExportOptions

                .ExportDestinationType = ExportDestinationType.DiskFile

                .ExportFormatType = ExportFormatType.PortableDocFormat

                .DestinationOptions = CrDiskFileDestinationOptions

                .FormatOptions = CrFormatTypeOptions

            End With

            docreport.Export()

           docreport.Dispose()

            GC.Collect()

At the time of export I am getting the Error:

Failed to load database information.

Details: The database DLL 'crdb_b1.dll' could not be loaded.

Error in File C:\Users\ADMINI~1\AppData\Local\Temp\temp_42765689-c8d3-4e8f-8fa1-2a0b6f37bd24 {E9C02E65-3637-41EF-B2C4-6117D5676CD4}

Can any one help me?

Note:

SAP : SAP Business One 8.81 (8.81.319) PL: 10

CR : Crystal Report 2008 CR Developer Version 12.1.0.892

Product Type : Full

Regards,

Silambu

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please check with SAP notes:

1758302 - Error while connecting to Crystal

Thanks & Regards,

Nagarajan

[silambarasan_rajendran · Accepted solution]

Solved!

I have changed the connection settings in source code... Its been working now.

Thanks,

Silambu

[Former Member · Accepted solution]

Dear Silambu,

Can u brief me as I am facing same issue.

With Regards,

Rajesh Rana

[silambarasan_rajendran · Accepted solution]

Hi Rajesh,

Sorry for delay.  The above issue was solved by myself. I just edited in the visual studio and I got solution.

Regards,

Silambu

[Former Member]

Solution

This issue is caused by a failure current, upgraded or newly (installation sequence not followed) Crystal Reports installation.

To fix this please check one by one the suggested steps to fix the installation:

1. Crystal Report Integration Package
Locate the Crystal Reports folder (normally located) in shown directory path below:
C:\Program Files\sap\SAP Business One\Crystal\

• In the folder indicated in step one, locate the ‘SAP Business One Crystal Report Integration Package.exe’ file and run it on the computer where Crystal Reports Basic 2008 for SAP Business One is installed.
Note: The folder paths shown below may be different on your computer, depending on where you have installed SAP Business One and Crystal Reports 2008. You can use the Microsoft Windows search facility on your computer to locate the folders and files mentioned in the instructions below.

a. In the C:\Program Files\SAP\SAP Business One\Crystal folder, locate the crdb_b1.dll file.

b. Copy the crdb_b1.dll file to the C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86j folder, which contains the Crystal Reports 2008 crw32.exe executable file.

c. In the C:\Program Files\SAP\SAP Business One\Crystal folder, locate the following files:
- cscB1CRAddIn.dll
- Interop.SAPbobsCOM.dll
- Interop.SAPbouiCOM.dll

d. Copy the files to the C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\Addins folder.

2. Change 'B1CRBridge.dll'

a. Go to folder where SAP Business One executable is located (standard is C:\Program Files (x86)\SAP\SAP Business One)
b. Rename the following file B1CRBridge.dll to B1CRBridge_original.dll
c. Paste the file from attachment here (unzip before).
d. Test the issue again

[silambarasan_rajendran]

solved

[Former Member]

A mi me funciono reinstalando el "SAp Business ONE Crystal Report Integration Packages"  ...aparecia el mismo error al conectar al servidor SQL

[silambarasan_rajendran]

sorry, I unable to understand your language

[Former Member]

Solution

_ Reinstall "SAp Business ONE Crystal Report Integration Package"

_ Reinstall "SAP Crystal Reports runtime engine for .NET Framework"

Regard

Eduardo Suazo

[Former Member]

Hi,

I had upgraded SAP Business 8.82 to 9.0 but now I am unable to edit / execute my already developed crystal reports rpts as following error is showing. Can anyone help me out of this error ?

With regards,

Rajesh Rana

[kothandaraman_nagarajan]

Hi,

Please post as new discussion. This is standard forum rule.

Thanks & Regards,

Nagarajan

[Former Member]

Please let me know how to and from where to get these above installation packages.