Solved

ERROR linked server MSDORA ORA-12154, ODBC works

Posted on 2009-07-08
2
1,445 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
ID: 24808644
FYI MDAC vs 2.8sp1
Oracle client vs 10.2.0
0
 

Accepted Solution

by:
krush870 earned 0 total points
ID: 24818777
Looks like second reboot resolved the issues.  
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Get the parent node - XMLTYPE 9 70
exp/imp 25 73
Create Index on a Materialized View 5 20
pl/sql - query very slow 26 57
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

813 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

16 Experts available now in Live!

Get 1:1 Help Now