Re: ADO MSSQL7 and two independent transactions
From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 04/23/04
- Next message: John Faris: "Re: TAdoQuery.Locate and TDateTime fields"
- Previous message: Neil Joyce: "Re: Retrieving a memo field from access - disregard."
- In reply to: Kysy: "ADO MSSQL7 and two independent transactions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 23 Apr 2004 14:19:26 +0400
No, ADO connection corresponds to OLEDB session, not to OLEDB data source.
You may open 2 connections and ADO will use connection pool, so on low level
there will be one OLEDB data source object and 2 session objects.
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Kysy" <krzys@zeto.swidnica.pl> сообщил/сообщила в новостях следующее:
news:4088c5a4@newsgroups.borland.com...
> Is possible to open two independent (parallel) transactions on one
> connection?
> In InterBase-VCL we have TIBTransaction classess. In ADO (Delphi6)
> BeginTrans and other transaction-flow methods are stored in TADOConnection
> class. I dont want nested transactions, just save logs from one
transaction
> even if this transaction must be rollback.
>
> K
>
>
- Next message: John Faris: "Re: TAdoQuery.Locate and TDateTime fields"
- Previous message: Neil Joyce: "Re: Retrieving a memo field from access - disregard."
- In reply to: Kysy: "ADO MSSQL7 and two independent transactions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
