Cannot connect to the transaction manager or the transaction (-2147168229)
Quote:
> I get this error as soon as I mark a component as Requires New
Transaction
> in MTS.
> MSDTC is running. I am debugging locally. Gives different error if I
use
> OraOLEDB driver. Something like "Failed to enlist the transaction".
> The configuration is as follows;
> NT SP5 or SP6a (both tested)
> VB6
> ADO 2.5
> MTS 2.0
> Oracle 8.1.6
> Using OLEDB driver msdaora.dll
> Any help will be very much appreciated.
> S. Virk
Here is quote from MSDN
Oracle sometimes changes DLL names when they release new versions of
their product. Microsoft Transaction Server relies upon knowing the
names of some Oracle DLLs. MTS currently looks for the DLL names
provided with the Oracle 7.3 release. If Oracle renames these DLLs, you
must modify the values of the following registry keys:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Transaction Server\Local
Computer\My Computer
Under this key there are two string-named values.
OracleXaLib "xa73.dll"
OracleSqlLib "sqllib18.dll"
You must find OracleXaLib in your oracle dir and setup registry.
Sent via Deja.com http://www.deja.com/
Before you buy.
