CODEWITHSUNDEEP
c#.netdb2
Shetty
Shetty

Reputation: 1892

SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2

I am trying to connect to DB2 from .NET 2.0 application in my development machine running windows 7 64 bit.

I am getting this error in open method. Could not find a solution.

ExceptionType: InvalidOperationException ExceptionMessage: SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2, tokens D:.......................\bin\db2app.dll, StackTrace: at IBM.Data.DB2.DB2ConnPool.Open(DB2Connection connection, String& szConnectionString, DB2ConnSettings& ppSettings, Object& ppConn) at IBM.Data.DB2.DB2Connection.Open()

Upvotes: 14

Views: 25470

Answers (5)

Tejj
Tejj

Reputation: 191

I was also getting same error and While doing troubleshooting, I put in all my credentials for Server IP and database name manually rather than copy pasting and it worked fine.

Upvotes: 0

Shetty
Shetty

Reputation: 1892

Learnt this from a colleague of mine. Issue was because db2app.dll was missing in bin directory of application folder.

Copied db2app.dll and db2app64.dll from C:\Program Files\IBM\SQLLIB\BIN to bin folder of application and it worked fine.

Upvotes: 14

Jenson
Jenson

Reputation: 724

I had a 32 bit DB2 Client and I was accessing it from a Web Application hosted on IIS, using Application pool (with 'Enable 32-bit Application' set to false). In this case a 64 -bit client (db2app64.dll) is expected while db2app.dll will throw above error.

Just FYI.. It is hard to debug this error in Visual studio as by default IIS express uses 32-bit application pool. To change it to 64-bit, one has to make changes in registry (set Use64BitIISExpress to 1) There is no inetmgr for IIS Express.

Upvotes: 1

MrG
MrG

Reputation: 1623

See the "user response" at the bottom of the IBM doc for SQL1159N, which also lists the various reasons you might receive this error code:

There was a problem with your DB2 installation. If this is the first time DB2 was installed on this computer, review the install logs for any possible errors and run a repair of DB2 from the Add/Remove Programs control panel applet. The default location of the installation logs is the My Documents/DB2LOG folder of the user that performed the installation. If this does not resolve the issue please contact IBM Support and provide the reason code associated with this message along with any installation logs.

Upvotes: 2

user2735366
user2735366

Reputation: 1

After speaking to IBM, they recommend strongly against putting IBM dlls inside the bin folder. We let IBM remotely configure our server and now all works well and we must not put the ibm*.dll into our bin folders or it will not work.

Upvotes: 0

Related Questions