Re: ADO.Net Transactions

Tech-Archive recommends: Fix windows errors by optimizing your registry


"SteveL" <steve@xxxxxxxxxxxxx> wrote in message
news:uMmxnZpgFHA.328@xxxxxxxxxxxxxxxxxxxxxxx

> 1. How does ADO.Net invoke transactions. I am using the SQLConnection
and
> transation object and am not using COM+. Does it use it's own provider to
> control the transactions or does it use MSDTC?

I believe it works with SQL Server to do this. AFAIK the DTC is not
involved. I normally use COM+ though.

> 2. Can I enlist in a distributed transaction just using ADO.Net without
> using COM+ or is this only available from ADO.Net 2 onwards?

System.Transactions will let you do that, IIRC. I think one of Don Box's
blog entries talked about this.


--
Klaus H. Probst, MVP
http://www.simulplex.net/



.

Relevant Pages

  • Re: When can I use transactions in VB6 / ADO 2.8?
    ... Not supported through RDS, as it does not support persistent connections - ... RDS rides on port 80 / HTTP. ... It seems that transactions are not supported ... > provider other than ODBC? ...
    (microsoft.public.data.ado)
  • Re: When can I use transactions in VB6 / ADO 2.8?
    ... Not supported through RDS, as it does not support persistent connections - ... RDS rides on port 80 / HTTP. ... It seems that transactions are not supported ... > provider other than ODBC? ...
    (microsoft.public.vb.controls.internet)
  • Re: When can I use transactions in VB6 / ADO 2.8?
    ... Not supported through RDS, as it does not support persistent connections - ... RDS rides on port 80 / HTTP. ... It seems that transactions are not supported ... > provider other than ODBC? ...
    (microsoft.public.data.oledb)
  • Re: When can I use transactions in VB6 / ADO 2.8?
    ... Not supported through RDS, as it does not support persistent connections - ... RDS rides on port 80 / HTTP. ... It seems that transactions are not supported ... > provider other than ODBC? ...
    (microsoft.public.vb.database.ado)
  • Re: When can I use transactions in VB6 / ADO 2.8?
    ... Not supported through RDS, as it does not support persistent connections - ... RDS rides on port 80 / HTTP. ... It seems that transactions are not supported ... > provider other than ODBC? ...
    (microsoft.public.data.odbc)