Need to query special functions

  • Thread starter Thread starter Ignasi Giró
  • Start date Start date
I

Ignasi Giró

Hi everybody

I need to obtain as dataset a query result from an internal function of my
DB.

In my case is MySQL and when I execute it through a
DataAdapter.SelectCommand it goes wrong. But executing via Query-Analizer
shows what I want.

Is there any way to obtain that?

thanks a lot
 
What error are you getting? Which provider? Have you changed the
CommandType to the corresponding type you have?
 
[SQLCODE: <-51>:<SQL statement expected>]

That's the error. My provider is ODBC and my CommandType is default (Text) I
don't know which one must be.

The query that I'm sending is "show processlist" and, as the error
indicates, it isn't SQL standard, so I'm totally lost about how to execute
that.

Thanks!
 
Back
Top