Page 1 of 1

problem with lazarus and zeoslib 7

Posted: 02.11.2010, 20:11
by fsolispa
the point is this, is that I work with lazarus .0.28, had no problems until the update mysql, the version is 5.1 release, check the documentation that supports Zeoslib and comments to this version for ubuntu (linux) to which when deploying the protocol only goes up to version 5.0, new internet search and found an article that commented that I had to make a change the in. PAS where they found the drivers, I did what I mentioned change the parameters for I recognize the. os.16, and everything really well, like all programs and it still I had to put a dbgrid, started again, had to upgrade to version 0.29, had already solved the problem, so you can work with the dbgrid as I needed to do yet more problems, let me install everything to compile, install the components I use, within which this Zeoslib 7.0.0 alpha, with the modification that was made on the part of drivers, I can put the component connection, giving you all the attributes needed to connect to mysql server, username, protocol, port and password, it connects fine without problems but when I place a component dataset, I can relate to the connector to select the table name displays me the following error message:

SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE ' 0x1.b6d8p-886t line 1.

Click OK to ignore and run the risk of corrupting data. Press cancel to terminate the program.

Posted: 08.11.2010, 00:09
by mdaems
Please check using a TZSQLMonitor what exact query is sent to the server and why that is not correct.

The error message tells it is the mysql server that complains, not zeoslib itself.

Mark