sqlDB & MariaDB issues
lazarus / 16-Databases

----------------------------------------------------------------------
BSaidus · 2018-11-03 13:39

Hello,
I think that sqlDB do not support MariaDB server.
Could someone confirme me that ??
thks

----------------------------------------------------------------------
mangakissa · 2018-11-04 08:34

Please tell me what's wrong.

----------------------------------------------------------------------
BSaidus · 2018-11-04 09:59

I have mariaDB 10.2.8 server installed.
I have also lazarus 1.8.4/fpc3.0.4.
When I want to connect to this server using sqlDB I wont.
   I used 3 components for mysql connection.
     TMySQL55Connection
     TMySQL56Connection
     TMySQL57Connection
And if you look to screenshoots I have errors while connecting.

----------------------------------------------------------------------
HeavyUser · 2018-11-04 10:11

Quote from: BSaidus on November 04, 2018, 10:59:25 amI have mariaDB
10.2.8 server installed.
I have also lazarus 1.8.4/fpc3.0.4.
When I want to connect to this server using sqlDB I wont.
   I used 3 components for mysql connection.
     TMySQL55Connection
     TMySQL56Connection
     TMySQL57Connection
And if you look to screenshoots I have errors while connecting.
is the port correct? As far as I know the default port for MySQL and
mariadb is 3306 not 3308. other than that I would go with the 56
connection it seems to be the only one that does try to connect.

----------------------------------------------------------------------
BSaidus · 2018-11-04 10:29

yes correct, I changed it in MariaDB config File. 3308

----------------------------------------------------------------------
BSaidus · 2018-11-04 10:39

Oh yes !!
    5.6 is connected.
    I just copied libmariadb.dll to C:\Windows and rename it to
libmysql.dll then it works.