Solved

ERROR linked server MSDORA ORA-12154, ODBC works

Posted on 2009-07-08
2
1,443 Views
Last Modified: 2013-12-19
I am trying to link a MS SQL Server 2005 to an oracle 10g database.  I have tried MSDAORA provider and get ORA-12154 "TNS:Could not resolve names"  I have verifiy TNSNAMES.ora is correct and can connect ussing ORACLE ODBC.

I try using ORAOLEDB.Oracle and it gives OLE DB provider "oRAoledb.Oracle" for linked server "PACSTEST" returned message ""  MSG 7303

I have found conflicting answers on web if MSDORA supports 10g
Also I would like to verify MSDAORA is pointed correctly to my ORACLE client






0
Comment
Question by:krush870
  • 2
2 Comments
 

Author Comment

by:krush870
Comment Utility
FYI MDAC vs 2.8sp1
Oracle client vs 10.2.0
0
 

Accepted Solution

by:
krush870 earned 0 total points
Comment Utility
Looks like second reboot resolved the issues.  
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now