Toad World® Forums

Toad not compatible with db2 ESE v9.7 on Windows 7 64bit?

I installed Toad 4.6 on on Windows 7 64bit. The db2 is db2 ese v9.7.
When I tried to connect to the DB2 server, I am getting this error:
System.InvalidOperationException
SQL1159 Initialization error with DB2 .NET Data Provider, reason code 8, tokens 0, 128, 124
Stack Trace:
ÔÚ IBM.Data.DB2.DB2ConnPool.Open(DB2Connection connection, String& szConnectionString, DB2ConnSettings& ppSettings, Object& ppConn)
ÔÚ IBM.Data.DB2.DB2Connection.Open()
ÔÚ Quest.Toad.Db.Connection.OpenConnection(IDbConnection connection)
ÔÚ Quest.Toad.DB2.DB2ToadConnection.OpenConnection(IDbConnection connection)
ÔÚ Quest.Toad.Db.Connection.AllocConnection()
ÔÚ Quest.Toad.Db.Connection.Connect(Boolean notify)
ÔÚ Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()

I googled and someone said it was problem with db2 .net driver on Windows 7 64bit. So it means Toad can not work with db2 ese v9.7 on Windows 7 64bit? Any one can help to clarify? Or any workaround to solve it? Thanks!

Sorry, however Toad DB2 4.6 does not support Windows 7 64-bit OS Clients.If your Client OS is 64-bit, you will have to download and use Toad DB2 v4.7.You can download a trial Toad DB2 4.7 from:http://www.quest.com/db2/ If you purchased Toad DB2, you should also be able to download the commercial Toad DB2 v4.7 product from the quest supportlink site at:https://support.quest.com/Search/SearchDownloads.aspx?ActiveTab=1

I am running 4.6 on 64 bit windows 7, just had to make sure I used the 32 bit DB2 clients.

Try uninstalling your DB2 client and installing toad first.