SQLDB Firebird 3.0
lazarus / 16-Databases

----------------------------------------------------------------------
mig-31 · 2020-03-24 11:19

Hi,

In my project I want to migrate database Firebird 2.5 to Firebird 3.0.
I installed Firebird 3.0 and client library from my Mageia Linux 7.1
repository. I created a test database from FlameRobin and created the
sysdba user with standard password. 

I can't establish connection to test database from my test code using
SQLdb.
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i procedure
TForm1.Button1Click(Sender: TObject);begin  IBConnection1.HostName :=
'localhost';  IBConnection1.DatabaseName :=
'/var/lib/firebird/data/test.fdb';  IBConnection1.UserName :=
'sysdba';  IBConnection1.Password := 'masterkey';  try   
IBConnection1.Connected := True;  except    on E: Exception do
ShowMessage(E.Message);  end;end;     
I received an exception with message IBConnection1 : DoInternalConnect
: -connection rejected by remote interface

I try to connect to test database from Zeos lib and FlameRobin and
there is no problem.
What I do wrong?

My system
OS: Mageia Linux 7.1 64-bit
Firebird 3.0 and client library installed.
Lazarus 2.0.6 64-bit from official site.

Thank you for any suggestion.

----------------------------------------------------------------------
adilsonpazzini · 2020-03-24 12:15

did you point to the FBCLIENT 3 DLL?

----------------------------------------------------------------------
mig-31 · 2020-03-24 14:11

I think yes

there is the list of libraries

Code: Bash  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i bash-4.4$
ls /usr/lib64 |grep libfbclientlibfbclient.so.2libfbclient.so.3.0.4

----------------------------------------------------------------------
adilsonpazzini · 2020-03-24 14:54

Point it at the component "SQLDBLibraryLoader"..

          SQLDBLibraryLoader.ConnectionType:='Firebird';
         
SQLDBLibraryLoader.LibraryName:='/usr/lib64/libfbclient.so.3.0.4';
          SQLDBLibraryLoader.Enabled:=true;