Toad World® Forums

Unable to connect to DB2 database using toad 6.3 beta version on windows 7

Getting the below error while connecting to DB2 database.

System Information


Operating System
Microsoft Windows 7 Professional 6.1.7600 AMD64

DB Details.


DB21085I Instance “DB2” uses “32” bits and DB2 code release “SQL09075” with
level identifier “08060107”.
Informational tokens are “DB2 v9.7.500.4299”, “special_27924”, “IP23286_27924”,

and Fix Pack “5”.


Exception Information


Exception: System.EntryPointNotFoundException
Message : 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()

Requesting help.

Can you verify the version of the Microsoft .Net framework that you have?

Seems IBM code is trying to find a SQLFreeConnAttribsADONET method, but it cannot be found.

How many DB2 clients\environments do you have installed on that box?

Thanks.

Hi Jeff,

I have installed .Net Framework 4.5.1 as required by Toad 6.3.0 beta.

w.r.t. the clients I have installed IBM Data studio 4.2 for db2 and db2 Control Center applications. Not sure if this info you are looking for.

By clients\ Environments you mean the tools to access db2 database. ?

Toad supports DB2 clients v9.7.6 and above.

It seems you have a 9.7.5.x client - please upgrade your DB2 client to at least v9.7.6.

Thanks