Toad World® Forums

DB2 connection fails

Getting the same error in v6.0, 6.2 and 6.3. I created a new DB2 connection from a cataloged connection; when trying to open in 6.0 and 6.2 it dumps the stack trace:

System.ArgumentOutOfRangeException
Length cannot be less than zero.
Parameter name: length
Stack Trace:
at IBM.Data.DB2.DB2ConnPool.Open(DB2Connection connection, String& szConnectionString, DB2ConnSettings& ppSettings, Object& ppConn)
at IBM.Data.DB2.DB2Connection.Open()
at Quest.Toad.Db.Connection.OpenConnection(IDbConnection connection)
at Quest.Toad.DB2.DB2ToadConnection.OpenConnection(IDbConnection connection)
at Quest.Toad.Db.Connection.AllocConnection()
at Quest.Toad.Db.Connection.Connect(Boolean notify)
at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()

In 6.3 is appears to swallow the exception, but when I set the connection to connect at startup it displays:

(1) COT2 : Length cannot be less than zero.
Parameter name: length

Installation is on Windows Server 2012 R2 virtual machine with .NET 4.6.01055. I have the exact installation and .NET version on a Windows 7 machine that works fine, not sure what’s different with this installation. I’m using an AD account with local admin access on both machines. Thanks for any help!

We have not been able to recreate this issue.

Is there anything unique about your logon - like are you specifying a userid and or a password?

In 6.3 - can you try to specify a ‘connection string’ connection profile and see if that works/

Thanks.