Solved

'IBMDADB2' provider is not registered on the local machine.

Posted on 2006-07-11

1 solution

6,660 Views

Last Modified: 2012-08-13

Hello expeerts,

I am building a .net application on a windows server andrquired me to connect to a DB2 database using the follwoing connection string;-
TCP/IP:
Provider=IBMDADB2;Database=sample;HOSTNAME=db2host;PROTOCOL=TCPIP;PORT=50000;uid=myUserName;pwd=myPwd;

I have installed ;- DB2 Express-C (DB2 Express-C for Windows x86 32-bit) on my system, but when I run my .NET applIcationis get error;-
'IBMDADB2' provider is not registered on the local machine.

1. I did the same on a windows 2003 server and it worked fine. Is there an issue with 2000 server and IBM DB2.
2. How do I go about fixing the problem.

Comment

Question by:claracruz

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

5 Comments

LVL 4

Author Comment

by:claracruz

ID: 170813402006-07-11

I noticed that the dll was not registered, so I manually egistered this...

I can see the registered dll in the registry, but somehow, I still get the same error

LVL 13

Expert Comment

by:ghp7000

ID: 170835762006-07-11

stop and start the instance

LVL 4

Author Comment

by:claracruz

ID: 170877082006-07-11

about a million times, stil no joy

LVL 13

Accepted Solution

by:ghp7000

ghp7000 earned 500 total points

ID: 170965532006-07-12

unregister the dll, stop the instance, re register the dll, start the instance

LVL 7

Expert Comment

by:sachinwadhwa

ID: 170975792006-07-13

see here:

http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0402chong2/index.html

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Setting the Session Date Format in DB2 UDB for AS/400 / iSeries / System i

Article by: Gary

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400. Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level. I'm n…

Recursive SQL in DB2 (Converting rows to columns)

Article by: Kent

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions. It's not always easy to spot when recursion is called for, especially for people una…

Network monitoring: how to automate fixing common network or server issues?

Video by: AdRem

Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

Network monitoring: why having a policy is the best policy?

Video by: AdRem

Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…