Error Message with Oracle .NET Managed Provider

  • Thread starter Thread starter Robert
  • Start date Start date
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
 
Now that I have the Framework 1.1 downloaded, how do I reference the
.Net Oracle Provider 1.1? When I go to Project and Add Reference the
only Oracle Provider I see is version 1.0.

Robert
(e-mail address removed)
 
Back
Top