On Wed, Jul 03, 2002 at 11:34:17AM -0700, David L. Good wrote: > 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...
Please discuss on dbi-dev first as I'd like to consider defining a standard API for that kind of functionality. Tim.
