MS SQL Server DTS - DTS and Transactions

Author

DTS and Transactions

Axel Dahmen

2005-07-21, 11:24 am

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

Darren Green

2005-07-21, 8:24 pm

In message <ek$q0hgjFHA.1372@TK2MSFTNGP10.phx.gbl>, Axel Dahmen
<NO_SPAM@NoOneKnows.invalid> writes
>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
>
>
Have you tried BOL, it has sections on supported tasks and connections-

(mk:@MSITStore:C:\Pr
ogram%20Files\Micros
oft%20SQL%20Server%2
0Books%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

Axel Dahmen

2005-07-21, 8:24 pm

> Have you tried BOL, it has sections on supported tasks and connections-

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@reply-to-newsgroup-sqldts.com> schrieb im
Newsbeitrag news:2DAYq+D5$B4CFwE
P@sqldts.com...
> In message <ek$q0hgjFHA.1372@TK2MSFTNGP10.phx.gbl>, Axel Dahmen
> <NO_SPAM@NoOneKnows.invalid> writes
transaction[color=da
rkred]
> Have you tried BOL, it has sections on supported tasks and connections-
>
> (mk:@MSITStore:C:\Pr
ogram%20Files\Micros
oft%20SQL%20Server%2
0Books%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
>

Darren Green

2005-07-22, 7:23 am

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:\Pro
gram%20Files\Microso
ft%20SQL%20Server\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/defaul...kb;en-us;279857)

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

"Axel Dahmen" <NO_SPAM@NoOneKnows.invalid> wrote in message
news:u3kETDljFHA.3148@TK2MSFTNGP09.phx.gbl...
>
> 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@reply-to-newsgroup-sqldts.com> schrieb im
> Newsbeitrag news:2DAYq+D5$B4CFwE
P@sqldts.com...
> transaction
>
>

Axel Dahmen

2005-07-22, 7:23 am

> 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

Darren Green

2005-07-22, 11:23 am

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@NoOneKnows.invalid> wrote in message
news:%238IufHrjFHA.3608@TK2MSFTNGP12.phx.gbl...
>
> 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
>
>

Sponsored Links