There was a problem retrieving the list of OLEDB providers

Question

Post reply

There was a problem retrieving the list of OLEDB providers

Alexander-449406

SSC Veteran

Points: 213
More actions
November 3, 2007 at 1:36 pm

#119161

Good afternoon everyone,
I have a server with Windows 2003 64bit installed with SQL Server 2000 and Oracle 10g, there a few DTS that connect to Oracle and do some SQL tasks on Oracle DB using the following OLEDB provider ODAC10202x64Beta.
I have 3 problems:
1- When I open such DTS I get: "There was a problem retrieving the list of OLE DB providers"
2- When I schedule such DTS on a job it starts but never ends and I can't see any process running on SQL Server using sp_who active.
3- If I go to Data Sources in Control Panel and try to modify the user dsn created for those DTS I cannot open it, I get: "The setup routines for the Oracle on Oradb10g_home1 ODBC provider could not be found. Please reinstall the driver"
I downloaded and installed ODAC10203x64 which I thought would resolve the problem since it was not a beta, but I get exactly the same problem.... Any help trully appreciated!

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Big Data Man SSCrazy Eights Points: 8536 More actions · Answer 1

Hi,

I have experienced this problem not so long ago and the workaround was as follows:

1. Completely remove all previous references to Oracle Client

2. Restart server

3. Re-Install 64-bit Oracle10g Release 2 ODAC for Windows x64

(http://www.oracle.com/technology/software/tech/windows/odpnet/64-bit/utilsoft.html)

Hopefully, this should resolve problem, as it has worked for me.

Thanks,

Phillip Cox

Alexander-449406 SSC Veteran Points: 213 More actions · Answer 2

Thank you, I will schedule a restart of the server and give feedback if it fixes the problem.

Jportelas SSChasing Mays Points: 625 More actions · Answer 3

Hi there:

I have the same problem, I see the "there was a problem retrieving the list of OLE DB Providers", but I am not connecting to Oracle, just SQL Server 2000.

I found that sometimes this problem was fixed by re-registering the sqlOleDb.dll library, but in my case it did not work.

So I am still looking for answers because I can not edit my DTSs in this PC.

Any hints anyone?

Thanks for any help.

chandan_jha18 SSChampion Points: 11330 More actions · Answer 4

It can be fixed by re-registering a dll file

From the command prompt please navigate to:

C:\Program Files\Common Files\System\Ole DB folder

then type:- regsvr32.dll

You will receive a message that the dll has been registered successfully.

chandan_jha18 SSChampion Points: 11330 More actions · Answer 5

In your case re-installing the sql server tool componenets should help.It will ahrdly take an hour

Jportelas (1/21/2009)
Hi there:
I have the same problem, I see the "there was a problem retrieving the list of OLE DB Providers", but I am not connecting to Oracle, just SQL Server 2000.
I found that sometimes this problem was fixed by re-registering the sqlOleDb.dll library, but in my case it did not work.
So I am still looking for answers because I can not edit my DTSs in this PC.
Any hints anyone?
Thanks for any help.

Jportelas SSChasing Mays Points: 625 More actions · Answer 6

Re-installing did not work, I even installed the SP4 after reinstalling it and it did not work either.

Then I tried to re-register the sqlOleDb.dll and that did not work (even the regsvr32 sqloledb.dll command did not show any errors). Well it seems like it is a lost cause.

Thanks for the help, but it seems like it is not going to work anyway.