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:
SQL1159 Initialization error with DB2 .NET Data Provider, reason code 8, tokens 0, 128, 124
ÔÚ IBM.Data.DB2.DB2ConnPool.Open(DB2Connection connection, String& szConnectionString, DB2ConnSettings& ppSettings, Object& ppConn)
ÔÚ Quest.Toad.Db.Connection.OpenConnection(IDbConnection connection)
ÔÚ Quest.Toad.DB2.DB2ToadConnection.OpenConnection(IDbConnection connection)
ÔÚ Quest.Toad.Db.Connection.Connect(Boolean notify)
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!