Return
-
Title
'SQL1159 Initialization error with DB2 .NET Data Provider, reason code 3,' -
Description
User installed Toad on a new PC with Windows 7. Everything went fine until he intalled the DB2 Client seperatly and then created another DB2 intance. Since then when he tries to connect with Toad to any database he gets an error:
System.InvalidOperationException
'SQL1159 Initialization error with DB2 .NET Data Provider, reason code 3, tokens D:\Program Files (x86)\Quest Software\Toad for DB2 4.6\SQLLIB\bin\db2app.dll,'
-
Resolution
Use the db2switch command to change the default db2 instance from the instance created by the DB2 client install to the instance created by Toad. After doing that user imported all the connections successfully.