Conversion of ODBC to OLEDB for DB2 database

[Former Member]

Hi,

We use crystal report 2013 to create reports. The reports reside at a 64 bit server and currently the server has DB2 configured as 32 bit and BO4.0 SDK 32 bit installed. The plan is to upgrade the BO SDK to 4.2. Having 64 bit server and installing BO4.2 SDK 64 bit , configuring DB2 asin 64 bit odbc connection, the pdfs are not generated as expected.

The code used to export PDF from crystal report currently uses ODBC dll , i.e. crdb_ODBC.dll. We guess we can try with crdb_ado.dll But the other code/ parameters to set in are unknown. Any help with the code to use OLEDB ADO to connect to DB2 from crystal report in VB.NET code is welcomed.

Thanks in Advance.

[former_member11696]

Moved to BOE .NET SDK forum.

ODBC should work as long as you are setting your Application to use 64 bit runtime and if a WEB app the AppPool is also configured for 64 bit.

Don

[Former Member]

Thanks Don.

But when we try with 64 bit application, we get the error - Logon Failed.  Error in file. Unable to connect: incorrect logon parameter. This error occurs at settable location function. (This error occurred for both ODBC and OLEDB connections)

Note: Application - 64 bit, SDK - 64 bit, ODBC - 64 bit

[former_member11696]

Enable CRLogger and ODBC Trace and see what is being passed from the app.

Crlogger is our database component logger,

Search for CRlogger and you'll find KBA on h ow to enable it.

Don

[Former Member]

Thank you Don. I will check with CRLogger and ODBC trace

If we get some share sample code for connection to DB2 it will be very helpful.