error trying to create a linked server to Oracle from x64

Last Post 16 Feb 2009 10:49 AM by ogruizr. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ogruizr
New Member
New Member

--
13 Feb 2009 01:10 PM
Hi all:

I have the following installed in a x64 server:

Windows Server 2003 Enterprise x64 Edition.
SQL Server 2005 Enterprise edition.
Client for Oracle.

Now I am trying to create a linked server to Oracle with the following options:

Linked Server: LNK_TEST
Provider: Oracle Provider for OLE DB
Product Name: Oracle
Data Source: TEST

But I have an error message box with:

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "LNK_TEST".
OLE DB provider "OraOLEDB.Oracle" for linked server "LNK_TEST" returned message
"ORA-12557: TNSrotocol adapter not loadable. (Microsoft SQL Server, Error:7303)
ogruizr
New Member
New Member

--
13 Feb 2009 02:13 PM
TSN?

I checked TSN_ADMIN and It is SET.

I connected succesfully from x64 server to Oracle using sqlplus.
ogruizr
New Member
New Member

--
16 Feb 2009 03:59 AM
Is there a Microsoft's Oracle ole db provider for x64?
Where can I find it? is it at MDAC?
ogruizr
New Member
New Member

--
16 Feb 2009 10:49 AM
Yes, I did but Microsoft Oracle OLE DB provider was not.
You are not authorized to post a reply.

Acceptable Use Policy