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 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
pressed during the execution of the program on W2k? In my case the Perl
program was just waiting for a table lock to be released. This
particular lock was held by an orphaned connection so I pressed Ctrl-C
(resulting in yet another orphaned connection). By default it takes a
very long time (hours) for SQL Server to realize that a connection have
been orphaned. Would it be possible for DBI to autmatically close the
connections when Ctrl-C is pressed?
/Roger P
