DBD::ADO not returning error message
From: Tommy (ziggy.696040_at_bloglines.com)
Date: 09/27/04
- Next message: Kamran: "passing array as subquery to a SQL query"
- Previous message: Paul Falbe: "DBD::ODBC help"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 27 Sep 2004 12:00:53 -0700
I'm using DBD::ADO 2.92 with DBI 1.37 accessing a SQL Server 2000
database. When I attempt to restore a log for a standby database
while the database is in use, I get the following error in SQL Query
Analyzer:
Server: Msg 3101, Level 16, State 2, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
But when I try this from a perl script, the command fails, but I get
no error returned. Here's how I'm executing it:
$dbh->do("restore log tdw_standby from
disk='c:/logs/tdw_20040927132933.TRN' with norecovery");
print "dberr=$dbh->{err}\nerrstr=$dbh->{errstr}\n";
The $dbh->err and $dbh->errstr are both empty. I get the same results
if I use prepare and execute with a statement handle.
Am I doing something wrong?
Thanks,
Tommy
- Next message: Kamran: "passing array as subquery to a SQL query"
- Previous message: Paul Falbe: "DBD::ODBC help"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
