This is an FYI for others who might run into this situation. If you
have a database connection that does not support transactions. Most
notably Jet, dbase, active directory. you will get a 'cannot enlist'
or 'transaction no supported' exception if you open the connection
with in a transaction scope.
One workaround i read about was to open the connection before the
transaction. this doesn't help with RSB/RQ. The solution I found was
to use a suppressed transaction scope, for the specific connection. In
it's simplest form...
using(var scope = new TransactionScope(TransactionSopeOption.Supress))
using(var connection = new OleDbConnection("base connection string))
{
connection.Open();
//query dbase
}
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Rhino Tools Dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rhino-tools-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
