mORMot Open Source

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

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

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.

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

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)

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ł