#1 2020-08-20 01:53:18

taqtaq
Member
Registered: 2017-08-27
Posts: 3

Connect to Firebird

Hello, I installed mormot in Delphi and Lazarus.

The first task is to connect to a firebird database because I have done all my software using Firebird.

I was reading some documents or information for example here:

https://tamingthemormot.wordpress.com/c … tutorials/


But at the moment I can't understand how connect to Firebird so, I'm looking for an example where I can see a connection to a database firebird.
Where can I find a simple example?

Thanks

Offline

#2 2020-08-20 07:43:49

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,183
Website

Re: Connect to Firebird

You can search the doc.

For instance https://synopse.info/files/html/Synopse … #TITLE_192

See also the "Database Performance" sample, which has some sample connection strings.

Offline

#3 2020-08-20 23:46:02

taqtaq
Member
Registered: 2017-08-27
Posts: 3

Re: Connect to Firebird

I installed the last version of Zeos from https://sourceforge.net/projects/zeoslib/ (Ver. 7.2.6-stable)

Using:

uses
  Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
  Vcl.Controls, Vcl.Forms, Vcl.Dialogs,
    SynCommons,
  mORMot, mORMotSQLite3, mORMotDB,
  SynDB, SynDBSQLite3, SynDBDataSet,
  Vcl.StdCtrls, syndbzeos;

type
  TForm2 = class(TForm)
    Button1: TButton;
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
   PropsFirebirdRemote :   TSQLDBZEOSConnectionProperties;
  end;

Can't compile.

In unit SynDBZeos

 procedure TSQLDBZEOSStatement.ExecutePrepared;  

Error:

[dcc32 Error] SynDBZeos.pas(1107): E2034 Too many actual parameters
 ftBlob:     fStatement.SetBlob(i+FirstDbcIndex,stBinaryStream,
                    TZAbstractBlob.CreateWithData(Pointer(VData),length(VData)
                    {$ifndef ZEOS72UP}, fStatement.GetConnection{$endif}));

Thanks

Offline

#4 2020-08-21 01:13:00

Vitaly
Member
From: UAE
Registered: 2017-01-31
Posts: 168
Website

Re: Connect to Firebird

using Zeos trunk 6758, now - no problem with FB 2.5.9 (+ USE_SYNCOMMONS)

Offline

#5 2020-08-22 12:50:32

miab3
Member
From: Poland
Registered: 2014-10-01
Posts: 188

Re: Connect to Firebird

It is also worth testing the new ZEOS 7.3.1-beta (svn r6794):
https://zeoslib.sourceforge.io/viewtopi … 11#p155611
https://sourceforge.net/p/zeoslib/code- … sting-7.3/
It should be faster.

Michał

Offline

Board footer

Powered by FluxBB