Using Oracle Managed Data provider in a serviced component

S

Sachin Dhawade

We want to use the oracle data provider to access an
Oracle 8i database in serviced components that shall be
deployed in COM+.
The component has been deployed in COM+ using the
AutoComplete attribute, however if any database update
fails the transaction in COM+ does not get rolled back.

This work with the SQL data provider. Any ideas why this
is happenning.

Thanks
Sachin
 
A

Angel Saenz-Badillos[MS]

Sachin,
Can you post some more information regarding your setup?

OS, version of Oracle Client /server installed, what is the exception that
you are getting when you fail to update, have you verified that you are
enlisting into the COM+ transaction? How have you started/completed the
transaction (in .net or in Com+).

Any code will also be very helpful,
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oracle Data Provider for .NET (ODP.NET) 3
Microsoft Oracle Data Provider 3
Provider for Oracle database 2
Save Informix data using serviced com+ components of C# 1
Oracle 4
Connection string for Oracle Managed Data Provider from Microsoft. 6
Problems connecting to Oracle 9i database with Oracle 10g Client and Win XP x64 2
Oracle 8i connection using OLEDB 6

Top