Toad crash on connect

Toad for IBM DB2
1

Toad 6.0 on Win 7

Toad consistently crashes when opening a connection to a database. This is some of the detail from Event Viewer. Seems like it’s having trouble with DB2APP.dll

Can anyone give me a hint as to what’s wrong?

Application: toad.exe

Framework Version: v4.0.30319

Description: The process was terminated due to an unhandled exception.

Exception Info: System.AccessViolationException

Stack:

at IBM.Data.DB2.UnsafeNativeMethods+DB232.CSCStartTxnTimerADONET(IntPtr, Int32 ByRef)

at IBM.Data.DB2.DB2CscConnection.StartTxnTimer()

at IBM.Data.DB2.DB2Transaction.BeginTransaction()

at IBM.Data.DB2.DB2Connection.BeginTransactionObject(System.Data.IsolationLevel)

at IBM.Data.DB2.DB2Connection.BeginTransaction(System.Data.IsolationLevel)

at IBM.Data.DB2.DB2Connection.BeginTransaction()

at IBM.Data.DB2.DB2Connection.System.Data.IDbConnection.BeginTransaction()

at Quest.Toad.Db.Connection.BeginTransaction(System.Data.IDbConnection)

at Quest.Toad.DB2.DB2ToadConnection.BeginTransaction(System.Data.IDbConnection)

at Quest.Toad.Db.Connection.OpenConnection(System.Data.IDbConnection)

at Quest.Toad.DB2.DB2ToadConnection.OpenConnection(System.Data.IDbConnection)

at Quest.Toad.Db.Connection.AllocConnection()

at Quest.Toad.Db.Connection.Connect(Boolean)

at Quest.Toad.Db.Provider+BackgroundConnector.CreateBackgroundConnection()

at System.Threading.ThreadHelper.ThreadStart_Context(System.Object)

at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)

at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)

at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)

at System.Threading.ThreadHelper.ThreadStart()

=====================================================================

Faulting application name: toad.exe, version: 6.0.0.373, time stamp: 0x54639ac8

Faulting module name: DB2APP.dll, version: 10.5.600.232, time stamp: 0x55bc43c6

Exception code: 0xc0000005

Fault offset: 0x004167c5

Faulting process id: 0xde4

Faulting application start time: 0x01d10c5eb941bf67

Faulting application path: C:\Program Files\Dell\Toad for DB2 6.0\toad.exe

Faulting module path: C:\IBM\SQLLIB\BIN\DB2APP.dll

Report Id: 118309e7-7852-11e5-8582-0023240b2629

2

Hi, Andymcl.

Does Toad crash on every connection or just this 10.5 connection? Have you successfully connected to any database since installing v6.0?

-Steve

3

New install and it crashes on a connection to any cataloged db. All dbs are 10.5 and all are remote

4

We need some additional information:

What OS-bitness are you using? (i.e. Windows 7 32-bit OS or WIndows 7 64-bit OS)?

What DB2 client version and bitness are you using?

Can you successfully open the IBM DB2 CLP for your default copy and connect to your databases from that?

How many DB2 client copies do you have installed?

5

Win 7 Enterprise Edition 32 bit. One DB2 10.5 32 bit client. Successfully connect to databases from command line using the db2 client

6

I’ve uninstalled the db2 client and reinstalled and it works. The original client was a network distributed install. I reinstalled manually and it solved the problem. Thanks for the responses anyway