• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 767
  • Last Modified:

Link an Oracle DB to SQL Server

I am having trouble trying to link an Oracle DB to my SQL Server. I get this error:
"cannot create an instance of oraoledb.oracle"
I created a DSN that connects to it just fine, but when I make the connection in SQL Server I keep getting this error. Any help is appreciated. I'm using SQL Server 2008 R2 and Oracle 11g.
  • 3
  • 3
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>cannot create an instance of oraoledb.oracle
means normally that the oraoledb is not properly installed, or is not configured yet with the oracle home ...  or you have a 32bit vs 64bit mismatch ...
dodgerfanAuthor Commented:
What can you do for the 32bit v. 64 bit mismatch?
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you will have to make sure that the sql server installation "bit version" is the same as the oracle client "bit version".
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

dodgerfanAuthor Commented:
I verified that they are both 64 bit. I ensured Oracle home is configured. I am getting this error now:
"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
The ODBC connection is set up and connects when I test it. Once i create the linked server, I get this error when I test the connection. Am I missing something else?
Guy Hengel [angelIII / a3]Billing EngineerCommented:
can you show how exactly you configured the linked server?
dodgerfanAuthor Commented:
I used the sp_addlinkedserver procedure.
EXEC sp_addlinkedserver  

The this:
EXEC sp_addlinkedsrvlogin
@rmtsrvname=  'DevServ' ,
 @useself= 'FALSE',
 @locallogin=  NULL',
 @rmtuser=   'DBUser' ,
 @rmtpassword=   'Test' ;

It creates it, then when you test you get the error.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now