>Then you don't have mysql 4.1 on your client, but 4.0.24... >(this can be different from the server version)
You are right, I had client version 4.0. I did not know about server and client versions difference, thank you. >As far as I know, this is not a valid SQL statement in MySQL. >The MySQL command-line client treats it specially, and uses >the MySQL API to show the result of the statement. >Try something like >'select * from user'; You are right again. I tested this statement "show databases" from within MyAdmin or other MySQL clients and had proper results, thus I did not investigating tha direction. It is OK now, it is connected and exetuce above mentioned command. Panagiotis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Van Canneyt Sent: Tuesday, March 14, 2006 12:56 AM To: [email protected] Subject: RE: [lazarus] MySQL Connection On Mon, 13 Mar 2006, Panagiotis Sidiropoulos wrote: > > 2. I expect TSQL40Connection to give problems with MySQL 4.1.12-standard. > > I think you should use TSQL41Connection. > > Unfortunately they are not binary compatible. > > (Complaints should go to to [EMAIL PROTECTED]) > > TSQL41Connection raises an exception with message: > > "TSQL41Connection can not work with the installed MySQL client version > (4.0.24)." Then you don't have mysql 4.1 on your client, but 4.0.24... (this can be different from the server version) > > I checked this and thought that is caused because of MySQL version but > I'm not sure. > > > 1. Did you set the 'Database' property of your TSQLQuery component ? > > Sorry, TSQLQuery-TSQLConnection relation somehow was broken, I should > check once again, I apologise. Now, all seem to be in place but > running following code I get error: > - http://www.magentadb.gr/ftp/sql-conn.png > > at lines: > > SQLQuery1.SQL.Text := 'show databases'; > showmessage( SQLQuery1.SQL.Text ); > SQLQuery1.Open; > > SQL statement is just "show databases", as you can before executing I > check is once again using showmessage(). Trying from Windows Delphi, > It is connected using same user account. As far as I know, this is not a valid SQL statement in MySQL. The MySQL command-line client treats it specially, and uses the MySQL API to show the result of the statement. Try something like 'select * from user'; Michael. _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
