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 :-) > > 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. So I think the example in the wiki should be modified to show something else. Michael. _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
