Re: DBD-ODBC, MS SQL and locks

2003-02-04 Thread Roger Perttu
erttu [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 12:43 PM To: [EMAIL PROTECTED] Subject: DBD-ODBC, MS SQL and locks Hi! I'm having problems with table locks in MS SQL Server 7.0. I have more or less solved my problem using: $dbh->do('SET LOCK_TIMEOUT ' . LOCK_TI

RE: DBD-ODBC, MS SQL and locks

2003-02-03 Thread Joshua Caesar
Catch Ctrl-C as an exception , release your lock, let your program exit. -Original Message- From: Roger Perttu [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 12:43 PM To: [EMAIL PROTECTED] Subject: DBD-ODBC, MS SQL and locks Hi! I'm having problems with table locks

DBD-ODBC, MS SQL and locks

2003-02-03 Thread Roger Perttu
Hi! I'm having problems with table locks in MS SQL Server 7.0. I have more or less solved my problem using: $dbh->do('SET LOCK_TIMEOUT ' . LOCK_TIMEOUT); right after my call to DBI->connect(). I have a few questions though. I'm wondering if DBI or DBD-ODBC tries to do any clean up if Ctrl-C is