No Linked Server Providers

[dukeslater]

SQL Server 2000 linked server to Oracle was set up and working fine for over a year. It quit working - not sure what happened - but when I deleted it and tried to add it back, there are no providers in the dropdown.

I can add it via Query Analyzer, but it still won't work (error 7399).

Alternatively, I could add it to another SQL Server (and the providers do appear in all other servers), but I also get a 7399 error. This may be due to incorrect settings - I recall that setting up linked servers to Oracle is always a chore.


Any help would be greatly appreciated.

 

[ptheriault]

First thing to check is to make sure the Oracle client tools are still installed. Did someone remove them?

If you still have your client tools which you need for the connectivity drivers, check to the login. Try to login to the Oracle instance with that account.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[dukeslater]

Working now - Oracle client was working, but reinstalled MDAC and configured it normally.

Thanks for your help, but can anyone tell me why the MDAC components might vanish??