Has anybody been successful implementing COM+ Transactions with the Oracle 9i client using the Microsoft OLE DB Driver for Oracle (MSDAORA.1)? In my environment to support, I now have: Windows 2000 Server, Oracle 9i, MDAC 2.6, COM+ (VB 6 components). The only thing that has changed is going from the Oracle 8i client to Oracle 9i. My COM+ Transactions have worked fine in the Oracle 8i environment for 2 years.
Now, that I need to support Oracle 9i I have some success with transactions, but occasionally I'm getting flaky results with various errors ("Automation error The root transaction wanted to commit, but transaction aborted error '8004e002'" or "'80040200': Oracle error occurred, but error message could not be retrieved from Oracle."
. I
can get the error once and then retry and everything works fine. MS says it has been looking into support 9i for months, but doesn't look promising unless I go to .NET (which won't be soon). Is the Oracle OLE DB Driver the answer? I tried it and I'm getting "New transaction cannot enlist in the specified transaction coordinator". If this driver is the answer, where can I find documentation on how to get this to work?
Any help would be appreciated.
Now, that I need to support Oracle 9i I have some success with transactions, but occasionally I'm getting flaky results with various errors ("Automation error The root transaction wanted to commit, but transaction aborted error '8004e002'" or "'80040200': Oracle error occurred, but error message could not be retrieved from Oracle."
. Ican get the error once and then retry and everything works fine. MS says it has been looking into support 9i for months, but doesn't look promising unless I go to .NET (which won't be soon). Is the Oracle OLE DB Driver the answer? I tried it and I'm getting "New transaction cannot enlist in the specified transaction coordinator". If this driver is the answer, where can I find documentation on how to get this to work?
Any help would be appreciated.