Hi,

I I'm running a VB.NET windows applicatrion that is using the enterprise
services transactions.
the app is running on XP (SP2) and connecting to SQL2000 (version 8.00.760
(Build 3790: ) ) on windows 2003 (no SP).


first when running without enterprise services support, a connection is
established and data is brought fine.
when the class is configured to run inside enterprise services, the
connection.open method fails without error desctription.

i configured local DTC to enable distributed transactions.

please advise that required action in order to enable this kind of
transactions.

TIA!!


errors:

A first chance exception of type 'System.Data.OleDb.OleDbException' occurred
in system.data.dll
A first chance exception of type 'System.Data.OleDb.OleDbException' occurred
in system.data.dll
A first chance exception of type 'System.Data.OleDb.OleDbException' occurred
in system.enterpriseservices.dll
A first chance exception of type 'System.Data.OleDb.OleDbException' occurred
in system.enterpriseservices.dll
A first chance exception of type 'System.Data.OleDb.OleDbException' occurred
in system.data.dll
A first chance exception of type 'System.Data.OleDb.OleDbException' occurred
in system.data.dll
A first chance exception of type 'System.Data.OleDb.OleDbException' occurred
in system.enterpriseservices.dll
A first chance exception of type 'System.Data.OleDb.OleDbException' occurred
in system.enterpriseservices.dll
A first chance exception of type 'System.Data.OleDb.OleDbException' occurred
in mscorlib.dll
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred
in mscorlib.dll

"i configured local DTC to enable distributed transactions"
- Does this mean you enabled the DTC service within SQL Server (within the

no.

i mean under component services MMC snap-in - my computer properties,
MSDTC tab, security configuration.
the DTC in SQL server is shown as running,

still not solved.


[quoted text, click to view]