Details for connection establishment - Error occurs at 'SetTableLocation'

[Former Member]

Reports are generated from crystal reports using VB.NET code from DB2 database. In our existing system, we use ODBC dll CRDB_ODBC.dll. Below are the configurations of the current system, Server - 64 bit, BO SDK 4.0 32 bit, ODBC - 32 bit, .NET framework 4.0

Now we are using, server - 64 bit, BO SDK 4.2 64 bit, ODBC 64 bit and .NET framework 4.5.1

Without any change in the code, if we run the existing application in the server we get the below error.

Logon Failed. Error in file..rpt. Unable to connect: incorrect log on parameters. Error occurs at 'SetTableLocation'.

Help us solve the issue.

[former_member11696]

Create the exact same DSN in the 64 bit ODBC Admin then it should work.

64 bit DB2 client must also be installed

Don