Lazarus 2.0.4, ZeosLib 7.2.4 and MariaDB

In this forum you may discuss all issues concerning the Lazarus IDE and Freepascal (both running on Windows or Linux).

Moderators: gto, cipto_kh, EgonHugeist

Locked
radug
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 05.09.2019, 10:39

Lazarus 2.0.4, ZeosLib 7.2.4 and MariaDB

Post by radug »

Hi,

This is my first attempt to use Lazarus 2.0.4 (Win 10 64bit) with ZeosLib. I'm trying to create an application to manage an MariaDB/MySQL database. With little success so far.
I can use TZStoredProc and TZTable without problems but when I try to use TZQuery or TZReadOnlyQuery the program freezes upon the instruction:

Code: Select all

ZQuery1.Open;
or alternatively:

Code: Select all

ZQuery1.Active := true;
The code looks like this:

Code: Select all

procedure TForm1.ButtonConnectClick(Sender: TObject);
begin
  ZConnection1.Connected := true;
  ZQuery1.Close;
  ZQuery1.SQL.Clear; 
  ZQuery1.SQL.Text := 'SELECT * FROM table_users';
  ZQuery1.Active := true; // app freezes here!
  //ZQuery1.Open;
end;
For MariaDB 5.5, I use libmariadb.dll v3.1.3 and for MySQL 5.5, the connector libmysql.dll v5.5.62.

If I use TMysqlConnection55 and TSqlQuery the application works as expected.

Any ideas?

Thank you & Best regards,
Radu G.
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: Lazarus 2.0.4, ZeosLib 7.2.4 and MariaDB

Post by marsupilami »

Locked because it is a duplicate of http://zeoslib.sourceforge.net/viewtopi ... 8&t=100754
Locked