j.urban writes:
> I'm experiencing some unexpected and undesired behavior attempting to run
> SHOW COLUMNS FROM TABLE using Delphi via ADO.
>
> MDAC: 2.6 RTM
> MyODBC: 2.50.37
> O/S: Windows 98
> MySQL: 2.23.24 (Linux)
>
> I can run most queries just fine (ie SHOW TABLES, selects, etc.). However
> any SHOW COLUMNS queries return an error or an empty result set.
>
> If I attempt to connect the query to a visual control, the error message,
> "Data provider or other service returned and E_FAIL status". If I just
> attempt to connect the query and loop through the results, and empty
> result set is returned.
>
> I don't think an empty result set should be possible for a SHOW COLUMNS
> query. If the table doesn't exist, it will return an error and if the
> table does exist, there must be at least one column.
>
> I've tried several different versions of MDAC/ADO on several different
> computers, and DESCRIBE, EXPLAIN, and SHOW COLUMNS all exhibit this
> behavior.
>
> Anybody else experience this behavior or have any suggestions? Is this a
> limitation of accessing MySQL via ADO?
>
>
Please try to run the above via native interface, e.g. mysqlgui and
via some other ODBC connection, e.g. Access.
If several ODBC clients fail on the command, please send us ODBC
trace, so that we could take a look at it.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
