Distributed Transactions require Oracle9i client software

  • Thread starter Thread starter Vivek
  • Start date Start date
V

Vivek

Hi,

I get following error message when trying to work with
Oracle database with 8.1.7 client.
"Distributed Transactions require Oracle9i client software"

I am using .NET 1.1 and Microsoft provided Oracle Data
Provider. Also I am using this on Windows 2000 and
connecting to Oracle database with version 8.1.7.*.

Following article on msdn says that it should work with
8.1.7 and later.
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/cpguide/html/cpconadonetproviders.asp

I am using Enterprise Services (COM+) to implement
distributed transactions.

I don't mind to upgrade my client to 9i but wanted to make
sure that this doens't work in 8i.

-Thanks for reading this.
-Vivek.
 
Vivek,
The distributed transaction support on this provider is built on top of the
"Oracle Services for Microsoft Transaction Server" that ships with Oracle
Client v9.0 and higher so unfortunately to use this feature you need to
install the newer clients. For v9.0 and 9.1 this is an optional component
and must be installed from the custom configuration, this component installs
by default with Oracle 9.2. Be aware if you intend to use this with Oracle
8i server that there are two important known issues that have been resolved
in the latest OraMTS Release, from the Oracle web site:
http://otn.oracle.com/tech/windows/odpnet/faq.html#installDB
Q: I want to use the Oracle9i Release 2 version of OraMTS with an Oracle8i
database. I get a "No error information available:
XACT_E_NOENLIST(0x8004D00A)" error when running an application using OraMTS.

A: These are two known issues with OraMTS. These problems can be resolved if
you upgrade to OraMTS version 9.2.0.1.1 or higher.

Hope this helps,
 
Back
Top