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?
query,sql,mysql,homer
---------------------------------------------------------------------
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
