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

In message <ek$q0hgjFHA.1372 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Axel Dahmen
<NO_SPAM (AT) NoOneKnows (DOT) invalid> writes

(mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server%20Books%20Onli
ne\1033\dtssql.chm::/dts_addf_tx_660j.htm)


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thanks for trying to help me. Actually I have read and know *whole* BOL
about DTS. Unfortunately it doesn't say anything about transactions not
working on Access or on two connections coming from the same SQL server
instance. Neither does the page you gave.

These flaws have been confirmed in newsgroup discussions, not in BOL.

I thought someone might have waded through all possible configurations
(should be 16) and transaction parameters and has perhaps made a table from
it. It would help me a lot.

Axel Dahmen


-----------------
"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> schrieb im
Newsbeitrag news:2DAYq+D5$B4CFwEP (AT) sqldts (DOT) com...

The Jet provider is not listed as supported, and cannot be confused with any
of the supported options so that confirms it for me.
For more confirmation, a quick BOL search gave me this-

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\acdata.chm::/ac_8_qd_12_15ma.htm

The same server transaction problem is acknowledged -

BUG: Error 3910, "Transaction Context in Use by Another Session"
(http://support.microsoft.com/default...b;en-us;279857)



--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Axel Dahmen" <NO_SPAM (AT) NoOneKnows (DOT) invalid> wrote

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"...


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

The Jet provider has been tested for use within SQL, but the "Use in
distributed transactions" column sort of makes the table you suggest, but
not quite DTS focused.


"Axel Dahmen" <NO_SPAM (AT) NoOneKnows (DOT) invalid> wrote