Trying to connect to a "IBM DB2 iSeries" connection, one gets:
Quest.Toad.Exceptions.DatabaseException: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
Stack trace:
at Quest.Toad.NativeOdbc.OdbcDriverManager.PerformConnectionWithCompletionMode(OdbcHandle connectionHandle, IntPtr parentWindowHandle, String connectionStringIn, DRIVER_COMPLETION_MODES completionMode)
at Quest.Toad.NativeOdbc.NativeOdbcConnection.Open()
at Quest.Toad.Db.Connection.OpenConnection(IDbConnection connection)
at Quest.Toad.Odbc.OdbcToadConnection.OpenConnection(IDbConnection connection)
at Quest.Toad.Db.Connection.AllocConnection()
at Quest.Toad.Db.Connection.Connect(Boolean notify)
at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()
MUST CONSIDER:
1. – When going to the "ODBC Data Source Administrator | System DSN | CLI/ODBC Settings", and running a TEST, it says: "Connection tested successfully".
2. – Also, using the same PC, same Toad, but a different user, Toad connects.
