DTS and Transactions

Hi,

DTS and transactions seems to be an always recurring flaw in DTS.

Is there some HTML page around giving a quick overview of which transaction
parameters are allowed with different configurations, like SQL->Access or
SQL->same SQL?

Best would be some Pivot table, having configuration as X-axis and
transaction property as Y-axis.

TIA,
Axel Dahmen

> The Jet provider is not listed as supported
> For more confirmation, a quick BOL search gave me this-

Then your edition is different from mine (SP3+). Mine says:

"Einige der getesteten OLE DB-Provider werden mit SQL Server 2000
installiert:
[...]
Microsoft OLE DB Provider für Jet"

translated:

"Some of the TESTED OLE DB-Providers are already installed with
SQL Server 2000"...


> The same server transaction problem is acknowledged -
> BUG: Error 3910, "Transaction Context in Use by Another Session"

I know... I'm afraid this thread leads to nowhere. My question was if
someone has created a table with transaction options available/not available
for all possible constellations and drivers. Obviously this table doesn't
exist yet.

Tnx,
Axel