Using TransactionScope on Oracle

Topics: Data Access Application Block
Jul 8, 2009 at 5:11 PM

Hello, we are using DAAB and TransactionScope on Oracle.

Our application manage all the connection to only 1 database.

This type of implementation it seems to need "Oramts.dll".

Is there a way of using your DAAB and TrasnsactionScope without MTS?

Thanks!

 

Jul 9, 2009 at 2:45 AM

No, the dependency actually roots from the underlying oracle provider of DAAB which is the System.Data.OracleClient (http://support.microsoft.com/kb/843044). 

 

Sarah Urmeneta
Global Technology and Solutions
Avanade, Inc.
entlib.support@avanade.com

 

Jul 9, 2009 at 4:56 PM

In your link we read: “The System.Data.OracleClient assembly uses the Oramts.dll file when you perform distributed transaction activities. The System.Data.OracleClient assembly does not load when you try to perform nontransacted activities, or when you use local transactions”.

So I have 2 question:

1)      We don’t use “distributed transaction”… and so we don’t understand why we have this dependency. (we obtain: System.Data.OracleClient: Unable to load DLL (oramts.dll)). Why?

2)      Assuming that we don’t use distributed transaction” If we use DAAB without TransactionScope are we able to avoid to have this dependency ?

Thanks

Jul 10, 2009 at 9:42 AM
Edited Jul 10, 2009 at 9:42 AM

Hi,

I believe this could be an issue with the underlying oracle provider. And is out of the DAAB scope.

Valiant Dudan
Global Technology and Solutions
Avanade, Inc.
entlib.support@avanade.com