MSDAORA Linked Server with MSSQL Clustered DB

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mark (Mark_at_discussions.microsoft.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 07:09:01 -0700

Hello, We have a MS Clustered/MSSQL 2000 environment.
WIN2000 Server
MSSQL 2000
Oracle 9i Client
MDAC 2.8
We have a MSDAORA Linked server defined to INSERT, UPDATE, and DELETE into
an Oracle DB from our MSSQL DB. It works OK, it errors at times-see
another post. But when we move groups from one server to the next, we can
SELECT off the Linked Server but it Errors on starting a Distributed
Transaction (for INSERT, UPDATE, and DELETE's). We can eventually get it to
work on both servers individually, but when they failover, the distributed
transactions do not work.

I have reviewed both servers setup(related to linked servers to Oracle and
XA transactions) and they both look good.

Has anyone had this issue, and/or does anyone have any ideas on how to fix
this issue?

Thanks in advance,
Mark

Relevant Pages