Just a guess: You say, "I've already launched the command from SQLQuery Analizer: SET XACTABORT ON on both server." I wonder, does that only apply to the session you launched from? Can you check independently from another session whether this option is still on? HTH, Jim.
-----Original Message-----
From: CARENA LUISA CLOTILDE [mailto:CARENAL@BPN.IT]
Sent: Monday, December 30, 2002 8:16 AM
To: ARSLIST@ARSLIST.ORG
Subject: view form - SQL error
WARNING * Unable to start a nested transaction for OLE DB provider 'SQLOLEDB'. A nested transaction was required because the XACTABORT option was set to OFF. (SQL Server 7395)[OLE/DB provider returned message: Cannot start more transactions on this session.]
Hi,
This is the error i get if i try to update a record in a view form activating an escalation. I've already launched the command from SQLQuery Analizer: SET XACTABORT ON on both server.
ARS 5.1
SQL 2K
by
Luisa Carena
Help Desk Novara
SGS
Gruppo Banco Popolare di Verona e Novara
Tel 0321 663995
mailto carenal@bpn.it
***************************************************************************************
BPN - BANCA POPOLARE DI NOVARA S.p.A.
Sede Sociale e Centrale: via Negroni, 12 - 28100 Novara
Tel. +390321662111
CF e P.IVA: 01848410039 - Reg.Imp. Novara n. 1
Cod. ABI 5608
BPN non assume alcuna responsabilita' riguardo al contenuto del presente messaggio.
Le opinioni ivi espresse sono quelle dell'autore.
Il messaggio e' riservato esclusivamente al destinatario.
Il contenuto e gli allegati sono da considerarsi di natura confidenziale.
Nel caso abbiate ricevuto il presente messaggio per errore, siete pregati di telefonare
al numero sopra indicato.
***************************************************************************************
You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org
You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org
Previous Topic
Index