Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2006-07-11
5
Medium Priority
?
6,749 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
[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
  • 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 2000 total points
ID: 17096553
unregister the dll, stop the instance, re register the dll, start the instance
0

Featured Post

Implementing Azure Infrastructure Exam 70-533

This course is designed to familiarize and instruct students in the content that is covered by Microsoft Exam 70-533, Implementing Microsoft Azure Solutions. It focuses on all the November 2016 objective domain topics.

Question has a verified solution.

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

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 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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

730 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