Error Message with Oracle .NET Managed Provider

[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

 

[Banghe]

Oracle 1.1 is incl. in dot net 1.1. You do can download at MS site if
using dot net 1.0

 

[Robert Hill]

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)

 

[Banghe]

want to check this msg:
you can specify
http://www.dotnet247.com/247reference/msgs/29/147580.aspx

There is a config file in your computer, you might update the default
settings.

I was wrong, the oracleClient currently might be:1.0.5000 ?