[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

Autocommit und transactions

Peter Stojkovic

6/14/2004 4:44:00 PM

I am using a databaseconnection via ODBC to Sybase ASA 9.01
After updating a dataset and updating fails against table T1 ( Primary key
would not be unique ! ),
This is OK, That can happen in my program.
But after five Minutes,
I use the same connection for another Query to Table T2.
Now I get the OLD errormessage from Table T1 !!!


Is there a ROLLBACK needed or something else.

What i have to do, when an update of a dataset fails ??

Thanks for any help

Peter Stojkovic