R
Robert
"Failed to Initialize Distributed
Transaction"
I am trying to retrieve a dataset from an Oracle database
using the .Net Framework Managed Provider for Oracle via a
Web Service. When I reference my Web Service on my local
host, everything works fine. When I deploy the Web
Service to a Web Server, I can access some tables okay but
I get the error "Failed to Initialize Distributed
Transaction" when I try and get data from a table
containing a BLOB field. I have NOT tried to incorporate
a Distributed Transaction of any kind, just a straight sql
statement requesting data based on certain criteria. I
mention the BLOB field only because it is the sole
diffenece between the tables that can be accessed and the
one that fails.
An article KB322343 is referenced in the error message and
it says to use Distributed Transactions, I must have
the .NET Managed Provider for Oracle 1.1. I cannot locate
anything higher than 1.0 on the MS Website. Also it says
I need a newer version of the DLL Mtxoci.dll and I cannot
find that either.
Thanks,
Robert
Transaction"
I am trying to retrieve a dataset from an Oracle database
using the .Net Framework Managed Provider for Oracle via a
Web Service. When I reference my Web Service on my local
host, everything works fine. When I deploy the Web
Service to a Web Server, I can access some tables okay but
I get the error "Failed to Initialize Distributed
Transaction" when I try and get data from a table
containing a BLOB field. I have NOT tried to incorporate
a Distributed Transaction of any kind, just a straight sql
statement requesting data based on certain criteria. I
mention the BLOB field only because it is the sole
diffenece between the tables that can be accessed and the
one that fails.
An article KB322343 is referenced in the error message and
it says to use Distributed Transactions, I must have
the .NET Managed Provider for Oracle 1.1. I cannot locate
anything higher than 1.0 on the MS Website. Also it says
I need a newer version of the DLL Mtxoci.dll and I cannot
find that either.
Thanks,
Robert