Solved

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

Posted on 2006-07-11
5
6,457 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.
0
Comment
Question by:claracruz
  • 2
  • 2
5 Comments
 
LVL 4

Author Comment

by:claracruz
ID: 17081340
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
0
 
LVL 13

Expert Comment

by:ghp7000
ID: 17083576
stop and start the instance
0
 
LVL 4

Author Comment

by:claracruz
ID: 17087708
about a million times, stil no joy
0
 
LVL 13

Accepted Solution

by:
ghp7000 earned 500 total points
ID: 17096553
unregister the dll, stop the instance, re register the dll, start the instance
0
 
LVL 7

Expert Comment

by:sachinwadhwa
ID: 17097579
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

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…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question