Unable to find an entry point named 'SQLFreeConnAttribsADONET' in DLL 'db2app.dll'.

Toad for IBM DB2
1

Just downloaded ToadforDB2_Freeware_6.1.0.125 and installed it on Windows 8 machine. Tried to add connection to database. But got the following error

Unable to find an entry point named ‘SQLFreeConnAttribsADONET’ in DLL ‘db2app.dll’.

System.EntryPointNotFoundException
Unable to find an entry point named ‘SQLFreeConnAttribsADONET’ in DLL ‘db2app.dll’.
Stack Trace:
at IBM.Data.DB2.UnsafeNativeMethods.DB232.SQLFreeConnAttribsADONET(DB2SQLGetConnAttribsADONETParams& pParam)
at IBM.Data.DB2.ConnSettingsFromXmlConfig.Dispose(Boolean disposing)
at IBM.Data.DB2.ConnSettingsFromXmlConfig.Finalize()

Anyone knows what went wrong and how to fix it?

Thanks!

2

Hi,

This error indicates a problem with the DB2 client. It may be the version of your DB2 client is too old; Toad supports 9.7.6 and greater.

Another possibility is a corrrupted default client. Do you have a 32-bit and 64 bit client installed?

To help resolve this problem, I need to know your DB2 client types and versions.

Regards,

Adam

3

Hi Adam,

I’m using 32-bit db2 client.

C:\Program Files (x86)\IBM\SQLLIB\BIN>db2level

DB21085I Instance “DB2” uses “32” bits and DB2 code release “SQL09075” with

level identifier “08060107”.

Informational tokens are “DB2 v9.7.500.702”, “s111017”, “IP23286”, and Fix Pack

“5”.

Product is installed at “C:\PROGRA~2\IBM\SQLLIB” with DB2 Copy Name “DB2COPY1”.

Just to clarify, installed toad on windows 7 machine without any issue. But had to upgrade to windows 8 machine.

Thanks,

Chengyao

4

Hi Chengyao,

Toad DB2 6.1 supports 9.7.6 and greater. You need a newer client.

Adam

5

Hi Chengyao,

One thing I forgot to mention is DB2 installation on Windows 8.1 is not fully supported until 10.5 Fix Pack 4, 10.1 Fix Pack 4 and 9.7 Fix Pack 10. Try one of those clients.

Adam