Re: Linked Server Fails w/Error: 7399

From: Dejan Sarka (
Date: 03/10/04

Date: Wed, 10 Mar 2004 09:31:31 +0100

Check if these articles help:;en-us;280106;en-us;220915;en-us;277002

Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
"" <> wrote in
message news:6f5901c4061d$a857ef90$a601280a@phx.gbl...
> I'm trying to connnect from a SQL Server 7.0 db to an
> Oracle 8.i instance.  Connection is failing with the
> following error message:  Error 7399 OLE DB
> Provider 'MSDAOR' reported an error.
> I used the following ddl to create my linked server &
> linked server logon:
> exec
> sp_addlinkedserver 'CNRDAPRD', 'ORACLE', 'MSADORA', 'cnrdap
> rd'
> exec sp_addlinkedsrvlogin 'CNRDAPRD', 'false', 'local SQL
> Server logon', 'Oracle Server Logon', 'Oracle Server logon
> password'
> I can connect to the Oracle database from the box where
> I'm running SQL Server.
> When I issue: ping oracle server name from box running SQL
> Server I can ping server.
> When I issue tnsping oracle database name from box running
> SQL server I can ping Oracle database.
> When I issue sqlplus ORA logon/ORA password@ORA dbname I
> can logon to database so I know I can connect to the box
> and I'm using the right logon & password.
> Any help greatly appreciated.  Thanks in advance.