System.InvalidOperationException or other DB2 connection errors after installing .NET 4.5 as part of the TDP 3.6 installation.
Upgrading from 3.5 to 3.6 and migrated settings and connections with the built in utility.
After the migration, one can no longer connect to DB2 LUW or z/OS and receive the following exception:
System.InvalidOperationException SQL1159 Initialization error with DB2 .NET Data Provider, reason code 10, tokens 9.7.8, 9.7.6, Process Owner: CORP\A1PM33 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()
Run ‘Configure DB2 .NET Data Provider' from Start -> Programs -> IBM DB2 -> ‘default DB2 client name’ -> Set-up Tools.
Review IBM Support Document: http://www-01.ibm.com/support/docview.wss?uid=swg21429586 .
