Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've downloaded and install the ODAC for connecting oracle DB into my SQL Server 2008 using

The OleDB data provider for Oracle is now available in the SQL Server, but doesn't seems to be usable for now, Shall I install oracle 11gR2 client 64 bit on top of this ODAC ?

the following is the result of the right clicking the connection to the oracle server that I just created to test the server connection.

TITLE: Microsoft SQL Server Management Studio
The test connection to the linked server failed.
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "DW-DB_PROD".
OLE DB provider "OraOLEDB.Oracle" for linked server "DW-DB_PROD" returned message "ORA-12541: TNS:no listener". (Microsoft SQL Server, Error: 7303)

For help, click:


DW-DB_PROD is the DB instance name that is available and working from TNSPING command and I can get in from the SQLPLUS.

Any kind of help would be greatly appreciated.


share|improve this question
up vote 0 down vote accepted

Installing ODAC 11g 64 bit first in the SQL Server and then editing the TNS names solves the problem.

and set the following Environment variables:


after that drop the TNSNames into the C:\Oracle\Client\product\11.2.0\client_1\network\admin directory

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.