problem with lazarus and zeoslib 7

The alpha/beta tester's forum for ZeosLib 7.0.x series

Report problems concerning our Delphi 2009+ version and new Zeoslib 7.0 features here.

This is a forum that will be removed once the 7.X version goes into stable!!

Moderators: gto, EgonHugeist, olehs

Locked
fsolispa
Fresh Boarder
Fresh Boarder
Posts: 5
Joined: 21.10.2009, 18:35
Contact:

problem with lazarus and zeoslib 7

Post 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.
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post 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
Image
Locked