Hello,
Entity Framework based on dotConnect for Oracle 5.00.20, Oracle Express 10g, Windows 2003 Server, DTC service.
I have a WCF service method that starts a transaction with TransactionScope.
During transaction it recalls several other services that start an ObjectContext each. I receive always an exception which says "NET: Invalid SID".
I made a small project with a test to reproduce the situation, and I got always the same error: during transaction, after some ObjectContext creations, at SaveChenges it seems the provider cannot open the connection and throws that exception.
Thanks
Transaction Scope and Invalid SID error
Just a few details:
the problem isn't the SID name, the SID is correct, the connection is in direct mode.
The problem, more precisely, is:
in a transaction scope everything goes well until the number of queries is low, if the number of queries increases (there's no rule about how many), the provider starts to raise the invalid sid exception.
with query I mean a using statement with a new objectcontext (so in the transaction scope you have several times a creation and a dispose of an objectcontext).
As you suggest I sent you an email with the project
Thanks
the problem isn't the SID name, the SID is correct, the connection is in direct mode.
The problem, more precisely, is:
in a transaction scope everything goes well until the number of queries is low, if the number of queries increases (there's no rule about how many), the provider starts to raise the invalid sid exception.
with query I mean a using statement with a new objectcontext (so in the transaction scope you have several times a creation and a dispose of an objectcontext).
As you suggest I sent you an email with the project
Thanks