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
