There is a tran count system variable kept. You need to get to tran count 0 and then commit. MSSql and Sybase DBs have this tran count.
-----Original Message----- From: Ravishankar Narasimhan [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 31, 2002 6:04 PM To: [EMAIL PROTECTED] Subject: DBD-ODBC SQL Server 2000 and Transaction Control Hello, I am using Active State Perl 5.6.1 and DBD::ODBC to do some inserts on a SQL Server 2000 Database. I would like to have Transaction handling. I tried using Autocommit => 0. I tried using $dbh->do('BEGIN TRANSACTION' ) and $dbh->commit. $dbh->do( 'BEGIN TRANSACTION' ) and $dbh->( 'COMMIT TRANSACTION' ) $dbh->do('BEGIN TRANSACTION') and $dbh->( 'COMMIT' ). Nothing seems to work. Could any one in the group point me to correct way of getting this to work. Thanks, Ravi __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com
