Recent

Author Topic: sqlDB & MariaDB issues  (Read 3030 times)

BSaidus

  • Hero Member
  • *****
  • Posts: 540
  • lazarus 1.8.4 Win8.1 / cross FreeBSD
sqlDB & MariaDB issues
« on: November 03, 2018, 02:39:58 pm »
Hello,
I think that sqlDB do not support MariaDB server.
Could someone confirme me that ??
thks
lazarus 1.8.4 Win8.1 / cross FreeBSD
dhukmucmur vernadh!

mangakissa

  • Hero Member
  • *****
  • Posts: 1131
Re: sqlDB & MariaDB issues
« Reply #1 on: November 04, 2018, 09:34:28 am »
Please tell me what's wrong.
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

BSaidus

  • Hero Member
  • *****
  • Posts: 540
  • lazarus 1.8.4 Win8.1 / cross FreeBSD
Re: sqlDB & MariaDB issues
« Reply #2 on: November 04, 2018, 10:59:25 am »
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.
lazarus 1.8.4 Win8.1 / cross FreeBSD
dhukmucmur vernadh!

HeavyUser

  • Sr. Member
  • ****
  • Posts: 397
Re: sqlDB & MariaDB issues
« Reply #3 on: November 04, 2018, 11:11:44 am »
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.
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

  • Hero Member
  • *****
  • Posts: 540
  • lazarus 1.8.4 Win8.1 / cross FreeBSD
Re: sqlDB & MariaDB issues
« Reply #4 on: November 04, 2018, 11:29:08 am »
yes correct, I changed it in MariaDB config File. 3308
lazarus 1.8.4 Win8.1 / cross FreeBSD
dhukmucmur vernadh!

BSaidus

  • Hero Member
  • *****
  • Posts: 540
  • lazarus 1.8.4 Win8.1 / cross FreeBSD
Re: sqlDB & MariaDB issues
« Reply #5 on: November 04, 2018, 11:39:10 am »
Oh yes !!
    5.6 is connected.
    I just copied libmariadb.dll to C:\Windows and rename it to libmysql.dll then it works.
lazarus 1.8.4 Win8.1 / cross FreeBSD
dhukmucmur vernadh!

 

TinyPortal © 2005-2018