Recent

Author Topic: Error using TMySQL50Connection  (Read 3399 times)

Neuromancer

  • New Member
  • *
  • Posts: 44
    • My personal website
Error using TMySQL50Connection
« on: April 19, 2014, 05:32:55 pm »
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

  • Hero Member
  • *****
  • Posts: 668
    • exdatis
Re: Error using TMySQL50Connection
« Reply #1 on: April 19, 2014, 06:33:26 pm »

Neuromancer

  • New Member
  • *
  • Posts: 44
    • My personal website
Re: Error using TMySQL50Connection
« Reply #2 on: April 19, 2014, 06:42:04 pm »
It does not help me...

Do Lazarus work with MySQL 5.1 ?

exdatis

  • Hero Member
  • *****
  • Posts: 668
    • exdatis
Re: Error using TMySQL50Connection
« Reply #3 on: April 19, 2014, 06:46:07 pm »
I think that Lazarus 1.2 have both layer 5.1 and 5.5.
Please, OS, Lazarus version etc.
Regards
« Last Edit: April 19, 2014, 06:47:47 pm by exdatis »

eara

  • Jr. Member
  • **
  • Posts: 84
Re: Error using TMySQL50Connection
« Reply #4 on: April 20, 2014, 01:01:20 am »
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

  • New Member
  • *
  • Posts: 44
    • My personal website
Re: Error using TMySQL50Connection
« Reply #5 on: April 20, 2014, 03:11:12 pm »
I 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

  • Hero Member
  • *****
  • Posts: 668
    • exdatis
Re: Error using TMySQL50Connection
« Reply #6 on: April 20, 2014, 04:52:53 pm »
I suppose 32bit. So, try Lazarus 1.2. Good luck!

p.s. I prefer to use Firebird or PostgreSQL

mangakissa

  • Hero Member
  • *****
  • Posts: 1131
Re: Error using TMySQL50Connection
« Reply #7 on: April 21, 2014, 08:56:01 am »
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.
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

 

TinyPortal © 2005-2018