Need to query special functions

[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

 

[W.G. Ryan MVP]

What error are you getting? Which provider? Have you changed the
CommandType to the corresponding type you have?

 

[Ignasi Giró]

[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!