OracleConnection does not support parallel transactions

I got this message and I'm guessing that connections don't support multiple transactions. Can anyone tell me what they did to get around this issue.

Regards

Simion
LVL 1
simion_tishlerAsked:
Who is Participating?
 
PashaModConnect With a Mentor Commented:
Closed, 125 points refunded.
PashaMod
Community Support Moderator
0
 
123654789987Commented:
Refer this link

http://www.error-bank.com/microsoft.public.dotnet.framework.adonet/76907_Thread.aspx

It is about SqlServer but I think the same refers to oracle
0
 
Mohammed NasmanSoftware DeveloperCommented:
0
 
simion_tishlerAuthor Commented:
hey guys

I solved it my self. Actually there is no way it is possible to do parallel transactions. Oracle has something called saved points and the oracle data provider does not implement saved points. The  only way to used saved points is to use the execute sql command. Saved points are good but are not strictly parallel transactions.
The only way to get another transaction is to open a new connection. if you have a great server and a high speed lan then this is not a bad option.

Thanks for you help guys.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.