Have you tried using ASTA w/Delphi and MySQL? Using the ASTA MySQL Server you connect
like the native and the ASTA componets allow you to build your Client GUI from Delphi.
Very Slick! MySQL, the worlds greatest database<g>, seems to work just fine with it.
You can get the Server here http://www.astatech.com/support/servers.htm
You can download the ASTA Eval here http://www.astatech.com/asta26.htm
If you do decide to use ASTA and need any help feel free to E-mail me.
Mike Benzel [EMAIL PROTECTED] for NT Linux-Palm-CASL Support
Cross Platform Messaging and TDataSet Components: TAstaPDADataSets
Servers (Win32,Linux,Java) Clients (Win32,Linux,Java,Palm,WinCE,Linux PDA's)
ASTA Technology Group http://www.astatech.com ASTAWireless
http://www.astawireless.com
-----Original Message-----
FROM: Sinisa Milivojevic
TO: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
DATE: Fri 7/27/01 12:08
SUBJECT: Re: ADO + show columns
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
---------------------------------------------------------------------
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
