Problem with linked server to Oracle

I run linked server from SQL Server 2000 to Oracle 9.i. In SQL Server oracle client is xa73.dll.

EXEC sp_addlinkedserver @server='ORDB',
@provider='MSDAORA',
@srvproduct = 'Oracle',
@datasrc='ORDB'

EXEC sp_addlinkedsrvlogin
@rmtsrvname ='ORDB',
@useself ='false',
@locallogin =NULL,
@rmtuser = 'ivr',
@rmtpassword = 'jjcom'

SELECT * FROM OPENQUERY(ORDB,'SELECT * FROM SUBSCRIBER')

but get error like for the following :

Server: Msg 7399, Level 16, State 1, Line 2
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle error occurred, but error message could not be retrieved from Oracle.]

Please help me to get a solution

Answer this question

Problem with linked server to Oracle

Fernando Velásquez
Hi,

did you check those threads on the groups

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=56755&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19365&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=408756&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=417751&SiteID=1

The latter one including links for troubleshotting linked servers in Oracle.

HTH, jens Suessmeyer.

---
http://www.sqlserver2005.de
---
vvgalc
Hi Zoya,

I already install mdac 2.8 sp1 and try to execute query, the error message nos is :

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Error while trying to retrieve text for error ORA-01019
]
Crispin

Please try to install MDAC 2.8.

Thanks
shosholoza
Yes, I already checked those site and still get error.
Problem with linked server to Oracle

Answer this question