Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    2

    Unanswered: DBI continuing execution after a warning/informational message

    hi,
    I am executing a restore database (MS SQL Server 2005) from perl dbi.

    but restore stops after printing this message [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 168 pages for database 'aks1', file 'DBA_Test' on file 1. (SQL-01000)

    if run the restore database from sqlcmd, i get following output
    Processed 17632 pages for database 'aks1', file 'DBA_Test_Kline' on file 1.
    Processed 2 pages for database 'aks1', file 'DBA_Test_Kline_log' on file 1.
    RESTORE DATABASE successfully processed 17634 pages in 15.656 seconds (9.226 MB/sec).


    how can i make my dbi to continue executing after getting informational messages.

    thanks
    AK

  2. #2
    Join Date
    Dec 2007
    Posts
    2
    i changed prepare to include an option solved the problem
    my $sth = $db->prepare( $sql, { odbc_exec_direct => 1})

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •