On Mon, 2006-10-30 at 17:49 +0100, Michael Van Canneyt wrote: > > On Mon, 30 Oct 2006, Seth Grover wrote: > > > Before I dig in and spend a lot of time trying to figure out what's > > going on here, I thought I'd save the legwork ask to see if someone > > else has tried to do this. > > > > My question: will the TMySQL50Connection component work with a MySQL > > 5.1 (I think I'm running the 5.1.11 beta) server? > > A good and just question, to which we'd also like to know the answer :-)
the MySQL-developers said that they would better their lives, so there's hope... ;) btw: the biggest issue is if you can use the mysql5.1 client, the server doesn't matter much. > > I modified the example at > > http://wiki.lazarus.freepascal.org/index.php/MySQLDatabases to use a > > MySQL50Connection object. It looks like I can connect to the database, > > but when the demo tries to do the "show databases" query, I get an > > error from MySql which says "You have an error in your SQL syntax; > > IMHO: > That's because there is no 'show databases' SQL statement. > This is a fake SQL statement in the mysql command line utility, > which uses a native API call mysql_list_dbs. > > Same for the 'show index' statements. But as they are used frequently in MySQL, I build some exceptions in so that it should work. The 'show index' is there if you have tsqlquery.parsesql set to true. Try to set it to false. But nonetheless, it's a bug, so please provide a bug-report. > So I think the example in the wiki should be modified to show something else. That would be better, yes. Joost _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
