On Wed, Jul 03, 2002 at 09:43:53AM -0700, Michael Peppler <[EMAIL PROTECTED]> wrote:
> On Wed, 2002-07-03 at 09:28, Accardo, Glen wrote:
> >
> > I just tried to prepare/execute/fetch results for the following
> > a dbcc call in MS SQL Server. I get an error stating that
> > there is no select statement running--which is true.
> >
> > Is there a mechanism for getting the results of DBCC calls through
> > DBI? The do method doesn't seem to return anything more than
> > pass/fail, and what I need is all of the output from the
> > DBCC calls.
>
> DBCC output is sent as "error" messages. DBD::Sybase handles this by
> letting you define an ad-hoc error handler. Maybe DBD::ODBC has the same
> sort of functionality.
Nope, DBD::ODBC doesn't have that functionality. I submitted a patch a
couple of years ago to address the issue, but it kinda got lost in the
shuffle and I moved on to other projects without following up on it. I
hope to re-integrate the patch into the latest DBD::ODBC soon, but I'm
still trying to get access to an appropriate Windows box...
--
David Good [EMAIL PROTECTED]
This space intentionally left blank.
