DB2 Express C JDBC or ODBC connection

[Former Member]

I am trying to connect to DB2 for windows (db2 9.5 express connect) with either ODBC or JDBC. I am not having any success. I have downloaded the db2jcc and db2jcc4 along with the IBM Data Server Driver (ODBC).....where do I go from here.

[former_member11696]

Please re-post if this is still an issue to the Data Connectivity - Crystal Reports Forum or purchase a case and have a dedicated support engineer work with you directly

[Former Member]

FYI....

I was finally able to get the JDBC connection to work,but would like to have the ODBC working as well.

[Former Member]

Locally on the server the test connection works.....for ODBC.

but the instance of the ODBC driver actually living on the server was installed with the Database, and has DB2COPY2 in the ODBC driver name....

From my machine, there is no where to enter a server name manually as mentioned before.....

[Former Member]

It is 32 bit

[Former Member]

Then put the server name by yourself and neglect the Advanced tab

Please keep the thread updated so that we can proceed further or try something else.

Thanks

[Former Member]

for the ODBC Connection, I don't see a server option...

I see:

DataSourceName:

Alias (protected)

Description:

click the Add button and I see

Description:

UserID:

PassWord:

And and advanced settings tab for CLI Variables.

[Former Member]

Is your system 64 bit? if so you need to make changes to the registry. make sure you make a copy of the original exported reg files. The should be || in the text below should actually double backslashes. If I use double backslashes it changes the format of the text.

1) On 64 bit machines export the following keys from the registry.

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\IBM DB2 ODBC DRIVER

2) Edit the exported registry files.........

-

---

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\IBM DB2 ODBC DRIVER]

"UsageCount"=dword:00000001

"Driver"="C:||Program Files||IBM||SQLLIB||BIN||DB2CLIO.DLL"

"Setup"="C:||Program Files||IBM||SQLLIB||BIN||DB2ODBC64.DLL"

"CPTimeout"="60"

becomes

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\IBM DB2 ODBC DRIVER]

"UsageCount"=dword:00000001

"Driver"="C:||Program Files||IBM||SQLLIB||BIN||DB2CLI.DLL

"Setup"="C:||Program Files||IBM||SQLLIB||BIN||DB2ODBC.DLL"

"CPTimeout"="60"

3) Save the .reg files above and import them into the registry.

Edited by: Zilla Eh on Nov 11, 2008 12:29 AM

[Former Member]

Hi Chris

If you have installed the driver on the machine then you will be able to see the driver name listed the available driver's list.

Please follow the steps as below:

A] Create a DSN

1. Go to Start>>Control Panel>>Administrative Tools>>Data Source(ODBC).

2. In System DSN tab click on Add.A list of drivers will pop up

3. The name of your driver would be probably "IBM DB2 driver for........".

4.Enter the data source name/server/user name/password.

5. This will create the DSN.

B] Use the DSN to create report

1. Now open crystal reports,select blank report,under Create New Connection select ODBC(RDO).

2. Select the respective DSn which you created in step A and proceed further to create the report.

Let me know if this is what you are looking at.

Thanks