I haven't tried it in a long time (other than running make test) but from
perldoc DBD::ODBC:
odbc_async_exec
Allow asynchronous execution of queries. Right now,
this causes a spin-loop (with a small "sleep") until
the sql is complete. This is useful, however, if you
want the error handling and asynchronous messages (see
the err_handler) below. See t/20SQLServer.t for an
example of this.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
Development
On 11-Sep-2003 Jenda Krynicky wrote:
> Is there a way to execute an SQL command and get the messages, not
> the records?
>
> I mean, I'd like to run
> DBCC CHECKDB ('databasename')
> parse the output and add the result to a daily report of my servers'
> health. The question is how do I get the messages.
>
> I'm using DBI+DBD::ODBC and MS SQL Server 2000.
>
> Thanks, Jenda
> (And sorry if it's on line XX of the fine manual and I just did not
> find it:)
> ===== [EMAIL PROTECTED] === http://Jenda.Krynicky.cz =====
> When it comes to wine, women and song, wizards are allowed
> to get drunk and croon as much as they like.
> -- Terry Pratchett in Sourcery
