Sql1159 initialization error with DB2. NET data provider occurs after IIS is deployed.
Development uses. NET 2005 database uses db29, the problem is that when I am in. the system runs normally during the debugging and test run in the. NET environment, but exceptions occur when I run IIS.
Sql1159 initialization error with DB2. NET data provider, Reason code 2, tokens c: \ Program Files \ IBM \ sqllib_01 \ bin \ db2app. dll,
Note: An unhandled exception occurs during the execution of the current Web request. Check the stack trace information for details about the error and the source of the error in the code.
Exception details: system. invalidoperationexception: sql1159 initialization error with DB2. NET data provider, Reason code 2, tokens c: \ Program Files \ IBM \ sqllib_01 \ bin \ db2app. dll
Cause analysis:
Computer User Permissions
Solution:
Associate ASP. NET users with db2admins.