Cannot obtain the required Interface from OLE DB Provider “OraOLEDB.Oracle”

Today in the morning I was contacted by my fellow DBA to look into an issue with a linked Server he setup from SQL Server to Oracle. He did setup a linked server from SQL Server 2005 to an Oracle database and tested successfully(From SSMS). Well, everything appeared to be okay, but the app teams are unable to use this Linked server.


The DBA tried expanding catalogs->default and Oops…he is receiving this weird message.


This looks like missing permissions issue at Oracle end, but wait……..he was able to test the linked server successfully! So what did he miss?

The answer is “Allow Inprocess” for OraOLEDB.Oracle provider. Once I asked him to check that box, Voilaaaa….it works 🙂


For more information on the properties of these providers, please see

Happy Friday all!


One thought on “Cannot obtain the required Interface from OLE DB Provider “OraOLEDB.Oracle””

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: