Forum > Databases
TMySQL56Connection can not work with the installed MySQL client version
Thaddy:
Nonsense, Gordon
MariaDB never had a version 3.3. the oldest release was 5.1 and in sync with mySql 5.1.
3.3 is mysql and old
See tthe release history;
https://mariadb.com/kb/en/mariadb-releases/
Lazarus is also old if the mysql connectors do not have skipversioncheck.
Yor best place to start is with one of the older mysql connectors and a newer lazarus.
The Lazarus components themselvesmake no use of MariaDB specific features and MariaDB was upto version 11 almost 100% in sync with MySQL behavior and formats.
Main differences are the newer storage engines, but these are opaque to the Lazarus controls.They care only about the SQL dialects and these are compatible.
The true version can be revealed by typing mysql -V
same command worked also for mariadb, but is now changed to mariadb -V for versions beyong 10.
Mario:
Hi,
thanks for the answers!
AFAICT, mysql 3.3 is not installed on this system, unless something really really strange happened.
mysql --version returns
--- Code: Pascal [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---mysql Ver 15.1 Distrib 10.11.6-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
So basically I have no idea what is going on. But I'll try with the version specific TMySQL connector later.
Regards,
Mario
MarkMLl:
--- Quote from: Mario on June 16, 2024, 10:14:44 am ---AFAICT, mysql 3.3 is not installed on this system, unless something really really strange happened.
--- End quote ---
But something's pulled in an old client library. Try to track it down (i.e. probably a .so file) and then use apt-file to determine what package it's come from (which would probably merit a Debian bug report).
MarkMLl
CharlyTango:
Since mariadb is currently neglected in SQLDB, I recommend:
* Update to Lazarus 3.4
* ZEOS as access components (latest version 8.0 is available in the Online Package Manager OPM)
* As an access library, download the corresponding DLL (or the comparable Linux .so component) directly from MariaDB.org.
I use the same combination.
Thaddy:
That looks like a valid version. Try to use MySQL80 as connection.
Navigation
[0] Message Index
[#] Next page
[*] Previous page