SQL Server Linked server to Oracle

Question

I have a SQL server instance that has a Linked server to an Oracle instance on another box. We are receiving the below error.

    Msg 7302, Level 16, State 1, Line 2
    Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "MY_ORACLE".

Any ideas?

Andomar · Accepted Answer · 2010-09-15 18:23:54Z

3

Sounds like you haven't installed the OLE DB provider for Oracle. It has to be installed on the SQL Server machine. It's made by Microsoft and only available in a 32-bit version.

You're probably better off installing Oracle's own OLE DB drivers for windows. They're called the "Oracle Data Access Components for Windows" and you can find them here.

answered Sep 15, 2010 at 18:23

Andomar

239k55 gold badges387 silver badges412 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

MikeTWebb Over a year ago

@Andomar...I'll have the DBA take a look. That seems to make sense

MikeTWebb Over a year ago

@Andomar...looks like a server issue. They recycled the server last week and that fixed it. But, we made pathces this week. But it looks like a 32 vs 64 bit issue. Thanks

MikeTWebb · Accepted Answer · 2011-02-23 15:07:23Z

0

They recycled the server last week and that fixed it.

answered Feb 23, 2011 at 15:07

MikeTWebb

9,32726 gold badges97 silver badges134 bronze badges

Collectives™ on Stack Overflow

SQL Server Linked server to Oracle

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related