MSSQLTREK

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

Published by

sreekanth bandarla

on

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.

a

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

b

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 🙂

c

For more information on the properties of these providers, please see http://technet.microsoft.com/en-US/library/ms188095%28v=sql.90%29.aspx

Happy Friday all!

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

  1. Daniel Aya Avatar
    Daniel Aya

    Run Sql Management Studio as administrator worked for me

    Reply

Leave a comment

Hello,

I’m Sreekanth

Welcome to MSSQLTREK, my little corner of the internet where I geek out about SQL Server, databases, and all things cloud. This blog is my space to share lessons learned, cool tips, real-world troubleshooting stories, and the occasional deep dive into data and performance. Whether you’re a fellow Cloud Architect, DBA, Developer, or just cloud-curious, come along for the ride — let’s explore, optimize, and build awesome data solutions together!

Recent posts

Let’s connect

Join the party!

Stay updated with my posts…