Transaction with SET XACT_ABORT ON

From: Murat AKSAKAL ((maksakal_at_anadolufinans.com.tr))
Date: 05/28/04 

Date: Fri, 28 May 2004 06:56:02 -0700

    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