Error using TMySQL50Connection
lazarus / 16-Databases

----------------------------------------------------------------------
Neuromancer · 2014-04-19 15:32

Hello,

I am trying to connect to a MySQL database using a TMySQL50Connection
but I get the following error :

Code: [Select]TMySQL50Connection can not work with the installed MySQL
client version: Expected (5.0), got (5.5.35).

----------------------------------------------------------------------
exdatis · 2014-04-19 16:33

Your server version(5.5),
http://forum.lazarus.freepascal.org/index.php/topic,24209.0.html

----------------------------------------------------------------------
Neuromancer · 2014-04-19 16:42

It does not help me...

Do Lazarus work with MySQL 5.1 ?

----------------------------------------------------------------------
exdatis · 2014-04-19 16:46

I think that Lazarus 1.2 have both layer 5.1 and 5.5.
Please, OS, Lazarus version etc.
Regards

----------------------------------------------------------------------
eara · 2014-04-19 23:01

Download lazarus 1.2, it has a TMySQL55Connection and seems more
stable from previous version... or the use the TSQLConnector (and set
it to 5.5 version). For higher versions (e.g. 5.6 i don't ... now).

----------------------------------------------------------------------
Neuromancer · 2014-04-20 13:11

Quote from: exdatis on April 19, 2014, 06:46:07 pmI think that Lazarus
1.2 have both layer 5.1 and 5.5.
Please, OS, Lazarus version etc.
Regards
Lazarus 0.9.30.4-6 (Debian Wheezy package)
Lazrus FPC 2.6.0

----------------------------------------------------------------------
exdatis · 2014-04-20 14:52

I suppose 32bit. So, try Lazarus 1.2. Good luck!

p.s. I prefer to use Firebird or PostgreSQL

----------------------------------------------------------------------
mangakissa · 2014-04-21 06:56

The problem is the connector checks with version of mysql.dll you
have. Version 5.5 can't work with 5.1. The developers want you to use 
same version server and client, because they think there's are
differences in communications. I think client 5.5 can work with 5.1.
With DBExpress on Delphi there's no problem with client dll's. 
Google for dll version 5.1 or download mysqlserver 5.1 and use his
client dll.