SQL1159 Initialization error with DB2.NET data provider, reason code 7, tokens 9.5.0.DEF.2, SOFTWARE \ IBM \ DB2 \ InstalledCopies

Question

Am I trying to get a DB2 data provider from a 32-bit .Net application to connect to DB2 acting as a 32-bit application on Vista 64 (is it confusing enough)? Unfortunately, I get the following error:

SQL1159 Initialization error with DB2.NET data provider, reason code 7, tokens 9.5.0.DEF.2, SOFTWARE \ IBM \ DB2 \ InstalledCopies

There are a few posts in the IBM forums , but these are few helpful recommendations. Has anyone experienced this before? Or do you have better ideas for fixing it?

Answer 1

Do you need it to run as x86? I had similar problems with web applications under the Visual Studio dev web server (which was x86), but switching to IIS (x64) worked for me. Since I was deploying to IIS x64, I called it a day at that moment.

I tried tracking with Filemon and Regmon, but did not get any negative or missing keys. If I looked again, I would check HKLM \ Software \ WOW6432Node, guessing that the installer writes to the x64 HKLM \ Software node, but not to x86.

Answer 2

I vaguely remember that I had a similar problem with installing the DB2 for as / 400 oledb driver when trying to configure a linked server with sql 2005 on as / 400. It was a permissions issue, and in the end I found that only server sql accounts (not windows) can use the linked server, because (I think), then the driver was loaded using sql credentials instead of the ones issued to them. If it works when admin starts, it should be permission.

Answer 3

I assume you saw the entry SQL1159 in the DB2 Reference Guide ?

Unfortunately, for you, the reason codes stop at 6 and do not continue until 7. This says:

User Response: There was a problem installing DB2. If this is the first time that DB2 has been installed on this computer, look at the installation logs for any possible errors and start the DB2 recovery from the Add or Remove Programs control panel applet. The default location for installation logs is the My Documents / DB 2LOG folder of the user who performed the installation. If this does not solve the problem, contact IBM Support and provide the reason code associated with this message and any installation logs.

So, I think, try reinstalling it, and if the problem persists, you will have to contact IBM.

Sorry, I know that doesn't help much.

Answer 4

I uninstalled the previous 32-bit version, reinstalled it as 64-bit, and now I get a completely different error. It is referred to as requiring FP2 for the fix, but since I use Express-C, I cannot install the fix (IBM does not provide fixes for the free DB2 products). Anyway, thanks for the help. At least I can get closer to connecting. :)

Answer 5

I encountered this error on a Windows 2003 x86 server. My original problem was

Could not find the requested .net data provider. or may not be installed.

which led to comments that c: \ Windows \ Microsoft.NET \ Framework \ v2.0.50727 \ CONFIG \ machine.config did not have the required entries for the DbProviderFactories section. Indeed, there were no IBM DB2 records. When I manually added to the record, I then ran into this error, suggesting that there is more than just editing machine.config.

In any case, I uninstalled the IBM DB2 driver set, rebooted the system, reinstalled it, and initialized it correctly.

Answer 6

As a quick note ...

@Micheal: the link you used for SQL1159 is for version 9.1 documents
Version 9.5 documentation fits reason code 9
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.messages.sql.doc/doc/msql01159n.html

Unfortunately, I think there is a 10th reason code that is not documented there, but it is in the developerWorks section
http://www.ibm.com/developerworks/wikis/display/DB2/DB2+and+.NET+FAQ#DB2and.NETFAQ-WhatisSQL1159InitializationError%3F

Answer 7

I had the same issue with the DB2.net provider.

If you have Windows 64 bit, download and install the IBM Data Server Runtime Client (Windows AMD 64) version 9.5
from? _https: //www14.software.ibm.com/webapp/iwm/web/preLogin.do languages ​​= ru & source = SWG-idsrc11 & S_TACT = appddnet & S_CMP = ibm_im

If you run your program, you will get the following exception

Unhandled Exception: System.Overflow Exception: Arithmetic operation led to overflow. in IBM.Data.DB2.DB2ConnPool.Open (DB2Connection connection, StringszConnectionStringIn, DB2ConnSettings & ppSettings, Object & ppConn) in IBM.Data.DB2.DB2Connection.Open ()

Download and install the patch for your version of db2 from http://www-01.ibm.com/support/docview.wss?uid=swg1IZ09579

this will fix the problem.

Answer 8

Install DB2 Express-C for win x64, version 9.7.1 and it will work

Answer 9

I had a similar problem, my car is 64 bit. I installed both 32-bit and 64-bit db2 runtime clients, set the target structure to 32 bits in my project, worked fine for me. I was able to run the application on other 64-bit machines, they just need to set the 32-bit or 64-bit bit of the db2 runtime client, depending on the operating system.

Answer 10

Yes. This should happen on Windows 7, not Windows XP. Soul:

• right click project in solution browser
• Properties
• Compile tab (left side)
• Scroll down to see the Advanced Compile option button.
• Change the Target Cpu drop-down list to x86.