Initialization Error With Db2 Net Data Provider
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more sql1159 initialization error with db2 .net data provider reason code 8 about Stack Overflow the company Business Learn more about hiring developers or posting ads sql1159 reason code 3 with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow
Error [] [ibm][cli Driver] Sql0000w Statement Processing Was Successful.
is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2 up
Sql1159 Rc=7
vote 10 down vote favorite 1 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() c# .net db2 db2app64.dll download share|improve this question asked Sep 20 '11 at 11:27 Shetty 6472924 add a comment| 4 Answers 4 active oldest votes up vote 8 down vote accepted Learnt this from a colleauge 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 bib folder of application and it worked fine. share|improve this answer answered Sep 28 '11 at 6:47 Shetty 6472924 1 yes, you need to make sure that the DB2 driver suit is on the PATH –zinking Dec 6 '13 at 8:33 Thanks @Shetty, your answer resolved my problem –Rohit Vyas Nov 5 '15 at 20:10 add a comment| up vote 2 down vote 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 th
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack
Db2app.dll Download
Overflow the company Business Learn more about hiring developers or posting ads with us Stack db2 extended security Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL1159 Initialization error with DB2 .NET Data Provider, reason code 10, tokens 0.0.0, 9.7.3 up vote 2 http://stackoverflow.com/questions/7484349/sql1159-initialization-error-with-db2-net-data-provider-reason-code-2 down vote favorite I am trying to open a connection to DB2 in console application. It works fine. when I use the same code in a service, hosted in IIS it throws an error for DB2. Following is the error details. Am I missing some permissions in IIS ? dll :IBM.data.DB2.dll Code : DB2Connection db2Connection = new DB2Connection(connectionString); DB2Command cmdSelectUsrNameAndPassword = new DB2Command(querySelectUsernameAndPassword, db2Connection); cmdSelectUsrNameAndPassword.Connection.Open(); Throws : SQL1159 Initialization error with http://stackoverflow.com/questions/8118367/sql1159-initialization-error-with-db2-net-data-provider-reason-code-10-tokens DB2 .NET Data Provider, reason code 10, tokens 0.0.0, 9.7.3 If I try a DSN with ODBC in console it works, but same throws another error in IIS. OdbcConnection DbConnection = new OdbcConnection(DSNName); DbConnection.Open(); Throws : ASP.NET V4.0 does not have the authority to perform the requested command or operation. asp.net iis db2 share|improve this question edited Feb 25 '15 at 20:33 Grant Winney 45.6k54376 asked Nov 14 '11 at 7:11 Shetty 6472924 1 guess it has something to do with App pool identity. I set the app pool identity as "Network service" and gave full permission to "Network Service" on "IBM.Data.DB.dll" in C:\Program Files\IBM\SQLLIB\BIN\netf20_32\ Worked neat. –Shetty Nov 14 '11 at 11:58 possible duplicate of SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2 –zinking Dec 6 '13 at 8:34 add a comment| 3 Answers 3 active oldest votes up vote 3 down vote accepted guess it has something to do with App pool identity. I set the app pool identity as "Network service" and gave full permission to "Network Service" on "IBM.Data.DB.dll" in C:\Program Files\IBM\SQLLIB\BIN\netf20_32\ Worked neat. share|improve this answer answered Nov 14 '11 at 18:25 Shetty 6472924 the key is to ensure driver suit( of the same version ) is on PATH &nda
Web Platform Installer Get Help: Ask a Question in our Forums More Help Resources Blogs Forums Home IIS.NET Forums 64-bit Editions of IIS IIS in https://forums.iis.net/t/1149715.aspx?IBM+DB2+NET+Provider+in+32+bit+mode SySWoW Mode IBM DB2 .NET Provider in 32 bit mode IBM DB2 .NET Provider in 32 bit mode [Answered]RSS 3 replies Last post Jan 13, 2012 10:12 AM by bfranic ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Advanced Search Reply Letrix 2 Posts IBM DB2 .NET Provider in initialization error 32 bit mode Jun 05, 2008 11:35 AM|Letrix|LINK Hello, I'm using 64 bit version of WIndows 2008 Server Standard with IIS 7. I wanted to use Jet provider to access MS Access database so I have created new application pool and have enabled "Enable 32-Bit Applications". However I also use IBM DB2 provider and it doesn't want to initialization error with work in 32-Bit mode. There is following error: SQL1159 Initialization error with DB2 .NET Data Provider, reason code 3, tokens C:\Program Files\IBM\SQLLIB\bin\db2app64.dll When I installed 32 bit version of DB2 provider there was another error which stated: Exception Details: System.InvalidOperationException: SQL1159 Initialization error with DB2 .NET Data Provider, reason code 10, tokens 0.0.0, 9.5.1 I know this isn't best place to talk about such problems however I tryed almost everything to solve that problem. Thank you in advance for your help. Reply steve schofi... 5631 Posts MVPModerator Re: IBM DB2 .NET Provider in 32 bit mode Jun 05, 2008 11:33 PM|steve schofield|LINK I would check with IBM. I've run into this with 3rd party components, *most* times you just ned to install whatever version of the component (32 or 64) bit and it should work. The only advice I can offer is make sure the permissions are setup so the necessary app pool or IUSR accounts have permission to the files. Also, you can try installing in the GAC if y