Ravi,
AutoCommit => 0 and $dbh->commit() (or, of course, $dbh->rollback()) (Case sensitive AutoCommit) Jeff > -----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 >
