Re: Transaction with SET XACT_ABORT ON

From: Val Mazur (group51a_at_hotmail.com)
Date: 05/29/04 

Date: Fri, 28 May 2004 22:30:04 -0400

Hi Murat,

I do not know how you set EXACT_ABORT, but it is possible that you set this
option in another process, which will not make any affect for the current
transaction. Could you post the code, which sets this option and inserts
records? 

-- 
Val Mazur
Microsoft MVP
"Murat AKSAKAL" <Murat AKSAKAL (maksakal@anadolufinans.com.tr)> wrote in 
message news:EF40F4EC-0511-4AA8-968F-1BFC4568DC2B@microsoft.com...
>    I have very critical problem . I use ADO 2.7 ActiveX Component to 
> connect SQL SErver 2000 . Some place on my applications use ADO to start 
> Transaction on client-side following sample Code ;
>
> "
>  Dim  Cnn as ADODB.Connection
>  Set Cnn = New ADODB.Connection
>  Cnn .CursorLocation = adUseServer
>  Cnn .Open "Provider=sqloledb; Data Source=" & Server & ";Initial 
> Catalog=" & DB & ";User Id=" & User & ";Password=" & Password & ";"
>
>  cnn.BeginTrans
>  ........
> .........
> ........
> cnn.CommitTran
>
> "
>
> SQL Server 2000 user option which is " XACT_ABORT " set ON.
>
> I can not manage transaction integrity. In My SQL Statement there are alot 
> of insert to different table but after end of the transaction  there is 
> onyl one record on one table .  Where is the others ?
>
> Murat AKSAKAL
> Aplication developer Specialist
>

Relevant Pages

  • Re: INSERT Delay
    ... ADO sees them as a transaction (my bad for using the word ... Create a program that uses an ADO connection to SQL Server. ... Concatenate the three strings together with a CRLF between them. ... If they are not handled as a transaction, the first two should be committed ...
    (microsoft.public.sqlserver.programming)
  • Multi-Database Transactions
    ... I've been looking into adding transaction capabilities into my object ... transaction was done in a stored procedure or ADO ('classic ADO' or ... people were talking about data _sources_ instead of databases. ... using a single SQL Server 2000 Standard Edition with multiple databases ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: INSERT Delay
    ... While SQL Server may see them as ... > batch before) and causes them to handled as such. ... ADO does not do this unless you explicitly use a transaction. ...
    (microsoft.public.sqlserver.programming)
  • Re: CurrentProject.Connection
    ... > In order go begin transaction you need to create Cnn object, adjust the ... > Dim cnn as ADODB.Connection ... > I also recemend you to use error handler there. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: CurrentProject.Connection
    ... In order go begin transaction you need to create Cnn object, adjust the ... Dim cnn as ADODB.Connection ... I also recemend you to use error handler there. ...
    (microsoft.public.access.adp.sqlserver)