I'm in the process of upgrading the operating system from
Windows 2000 Advanced Server to Windows 2003 Server.

The server is clustered one is Windows 2000 Advanced
Server and the other Windows 2003 Server.

Before I upgraded the operated system both Linked Server
worked fine.

This is a linked server to an Oracle database. I was able
to connect to the database connection from sqlplus on this
server.

The linked server error is : Error 7399 "OLE DB
provider 'MSDAORA' reported an error.

Plese help me resolve this issue.

Thanks,

Jan K.

MS DTC must be configured as a cluster resource if you are using linked
servers. Please refer to this link for more info.
http://support.microsoft.com/default...&Product=sql2k

As it was working before the upgrade it is likely you have configured MS DTC
correctly.

The 7399 is a generic error message. You might want to set this trace flag
on and rerun your query to get a more meaningful error message

DBCC TRACEON (7300, 3604)

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html


"Jan K." <anonymous (AT) discussions (DOT) microsoft.com> wrote