Control hosted in Winforms Application:
Control in Editmode - new Form ShowDialog
Transactions with MSAccess mdb File
If you use Distributed Transactions within your Application and an Access .mdb a DataContainer then you maybe did get this:
System.InvalidOperationException: The ITransactionLocal interface is not supported by the 'Microsoft.Jet.OLEDB.4.0' provider. Local transactions are unavailable with the current provider.
SOLUTION:
Don't let Access participate in this Distributed Transaction
System.Transactions.TransactionScopeOption.Suppress
Msdn Link: Supporting Transactions in OLE DB
Entreprise Library: Exception Handling Policies
wir sind gerade bei der migration von Microsoft Oracle Client nach Oracle Data Provider.
WICHTIG in app.config
wenn man bei 2 exceptionTypes einfügt, greifen diese Regeln nicht!
weiss nicht wieso.
aber mit nur einer funzts.
wenn beide exceptionTypes drin sind, werden diese nicht abgehandlet.
KOMISCH
<exceptionHandling>
<exceptionPolicies>
<add name="Global Policy">
<exceptionTypes>
<add type="System.Exception, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" postHandlingAction="NotifyRethrow" name="Exception" />
</exceptionTypes>
</add>
<add name="DataAccess">
<exceptionTypes>
<add type="Oracle.DataAccess.Client.OracleException, Oracle.DataAccess, Version=1.102.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" postHandlingAction="ThrowNewException" name="OracleException">
<exceptionHandlers>
<add type="Siag.DataAccess.ExceptionHandler.OracleODPExceptionHandler, Siag.DataAccess" name="Custom Handler" />
</exceptionHandlers>
</add>
<!-- <add type="System.Data.OracleClient.OracleException, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" postHandlingAction="ThrowNewException" name="OracleException">
<exceptionHandlers>
<add type="Siag.DataAccess.ExceptionHandler.OracleExceptionHandler, Siag.DataAccess, Version=2.0.0.11969, Culture=neutral, PublicKeyToken=null" name="Custom Handler"/>
</exceptionHandlers>
</add>
-->
</exceptionTypes>
</add>
</exceptionPolicies>
</exceptionHandling>
Labels: coding, Enterprise Library
Subscribe to:
Posts (Atom)
Latest Posts
Popular Posts
-
*Updated* 26. September 2010: Updated with comments from Adam Cogan *Updated* 27. September 2010: Updated the comparison between anonymo...
-
It's easy I thought, just select the Property of the EntityType and set the Default Value in the Properties window to: DateTime.Now ...
-
Had some discussions about Lists and controls, like Listbox and Listview, and sometimes its difficult to distinguish those. System.Win...

