SqlDbx Forum

SqlDbx

You are not logged in.

#1 2011-07-19 12:31:22

cherukurimouli
Member

Error Identifying Database

When selecting Database Browser button  giving me error as follows

Unable to load DB2 Client library(DB2CLI.DLL or CWBODBC.DLL)

Thanks in Advance
Chandu

Offline

#2 2011-07-19 12:54:05

sqldbxhelp
Administrator

Re: Error Identifying Database

Make sure that you have DB2 Connect installed.

Offline

#3 2011-07-19 14:13:49

cherukurimouli
Member

Re: Error Identifying Database

We dont have DB2 Connect here
My DBA gave me db2cli.dll file where I have to keep this and how to connect

Offline

#4 2011-07-19 15:05:20

sqldbxhelp
Administrator

Re: Error Identifying Database

You can copy it to the same directory where SqlDbx.exe located or somewhere in a PATH variable.
If you do not have DB2 Connect I am not sure how available databases setup on your machine.
DB2 databases have to be cataloged in order to connect to them.

Offline

#5 2011-10-25 19:33:53

sl33py
Member

Re: Error Identifying Database

Hi, I have this same error...

I installed DB2 Connect as suggested, added the location of db2cli.dll to my system path and I still get the same error. I also experimented with:
- adding the path as it's full name (rather than "C:PROGR~1 etc" like it was originally in my path)
- copying the file to the same location as Sqldbx.exe as suggested, still no dice

Any ideas? Thanks for any help in advance...

Offline

#6 2011-10-25 20:12:46

sqldbxhelp
Administrator

Re: Error Identifying Database

The only reason for unable to load db2cli.dll message is that it's not in a path or some other dependent dll's not in a right place.
If you have DB2 Connect installed you can try to copy SqlDbx.exe into the same directory where db2cli.dll originally installed.
Usually it something like ...IBMSQLLIBBIN directory. If this does not help check that you can connect to DB2 using ODBC.

Offline

#7 2011-10-25 20:49:01

sl33py
Member

Re: Error Identifying Database

Thanks for the quick reply. Copying the exe to the location of the dll worked.

I will fiddle with the path more, but I needed it working asap so thankyou smile

Offline

#8 2018-11-03 06:57:37

Runor
Member

Re: Error Identifying Database

Make sure that you have DB2 Connect installed.

Offline

Board footer

Powered by FluxBB