Using System.Transactions with Oracle

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I trying to use System.Transactions with Oracle database. I'm getting the
"AccessViolationException" exception. I'm using
..Net Framework 2.0 and ASP.Net
Enterprise Library 2.0
Oracle 9.2.0.7
Windows XP Professional

I installed the complete ODAC before trying this. The following is the code
sample:

using (TransactionScope ts = new TransactionScope())
{
Database db1 = DatabaseFactory.CreateDatabase();
DbCommand dbc1 = db1.GetStoredProcCommand("Proc1");
db1.ExecuteNonQuery(dbc1);

Database db2 = DatabaseFactory.CreateDatabase();
DbCommand dbc2 = db2.GetStoredProcCommand("Proc1");
db2.ExecuteNonQuery(dbc2);

ts.Complete()

}

Am I missing anything here? Any help is appreciated.
 
Hi,

Based on my research, this might not be the trasaction problem. Could you
try to run the code again without using the trasaction? Does the
AccessViolationException throw again?

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
You are correct. There is no transaction problem. I'm using the self signed
SSL on my web site. It looks like it caused the problems. I could not view
the pages with "https". I restarted IIS and verified that the SSL works.
After this I didn't get any "accessviolation" exceptions.

Thank you
 
Hi,

It was nice to hear that you have had the problem resolved. Thanks for
sharing your experience with all the people here. If you have any
questions, please feel free to post them in the community.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Back
Top