The new dbx4fb.dll with Delphi Alexandria 11.2 not work ? about dbx4fb HOT 19 CLOSED

@moyzer . I can't be sure about this: Is it safe to go with "interbase"

However, you may try run the testcases with the interbase settings you want and see if it fit to your needs.

Big Thx :)
Best wishes...

from dbx4fb.

For the test :

I am using a DBExpress connection, adapted from :
https://www.idefixpack.de/blog/2010/11/dbx-without-deploying-dbxdrivers-ini/

from dbx4fb.

Unit_dbxdriver.txt

from dbx4fb.

Can you try with latest commits?

from dbx4fb.

Unfortunately gives the same error : "DBX Error : Not implemented"

• Compiled on 14/04/2023
• With Last Delphi 11.3
• With the last commits.

Maybe the problem is on the new Delphi release 11.3

I sent you a testCase.
Prg.zip

from dbx4fb.

The dbx4fb.dll driver will not support TDBXDynalinkDriverNative based drivers.

Try remove your DBXFireBird.pas driver and use RAD Studio native Data.DbxFirebird driver with the following changes:

uses Data.DbxFirebird, Data.SqlExpr;

procedure TForm3.Button1Click(Sender: TObject);
var C: TSQLConnection;
    CheminBase,
    LibraryName, VendorLib:string;
begin
  CheminBase:=ExtractFilePath(Application.ExeName) + 'Data\Base.fdb';
  LibraryName:=ExtractFilePath(Application.ExeName) + 'Data\dbx4fb.dll';
  VendorLib:='C:\Program Files (x86)\Firebird\Firebird_2_5\bin\fbclient.dll';

  //=================================
  C := TSQLConnection.Create(Self);

//  C.DriverName := 'FireBirdConnection';
//  C.LibraryName :=LibraryName;
//  C.VendorLib :=VendorLib;
  C.DriverName := 'Firebird';    // use DriverName defined in Data.DbxFirebird.pas

  C.GetDriverFunc := 'getSQLDriverFIREBIRD';

  C.Params.Clear;
  C.Params.Add('User_Name=SYSDBA');
  C.Params.Add('Password=masterkey');
  C.Params.Add('Database=' + CheminBase);
  C.Params.Add('LibraryName=' + LibraryName);  // Specify LibraryName here
  C.Params.Add('VendorLib=' + VendorLib);  // Specify VendorLib here
  C.Open;
  //=================================
  if C.Connected then
   showmessage('OK')
  else
   beep;
end;

from dbx4fb.

My Delphi 11.3 Professional, don'nt recognize the uses Data.DbxFirebird
Where can I get it ?
Thx.

On C:\Program Files (x86)\Embarcadero\Studio\22.0\source\data\dbx
There is no Data.DBXFirebird.pas

from dbx4fb.

Hello, I've been using the dbx4fb for a long time. Thank you very much for that!
The last version that works for me is 4.1.2022.58.
With the versions from 4.1.2022.59 onwards, I could no longer connect to a database.
I have never investigated this in depth, so I am still on 4.1.2022.58.
At the moment I'm working with RAD Studio 11.3 (compiling for Win64 using C++).
The problem was already with RAD Studio 11.2 and 11.1.5.

from dbx4fb.

My Delphi 11.3 Professional, don'nt recognize the uses Data.DbxFirebird Where can I get it ? Thx.

On C:\Program Files (x86)\Embarcadero\Studio\22.0\source\data\dbx There is no Data.DBXFirebird.pas

Is there Data.DbxFirebird.dcu in the RAD Studio folder? I am not quite sure if it is only available in Enterprise version and beyond.

from dbx4fb.

Hello, I've been using the dbx4fb for a long time. Thank you very much for that! The last version that works for me is 4.1.2022.58. With the versions from 4.1.2022.59 onwards, I could no longer connect to a database. I have never investigated this in depth, so I am still on 4.1.2022.58. At the moment I'm working with RAD Studio 11.3 (compiling for Win64 using C++). The problem was already with RAD Studio 11.2 and 11.1.5.

Is the current build: 4.1.2023.62 works for you?

from dbx4fb.

no - .59, .60, .61 and .62 do not work for me.

I have Data.DbxFirebird.dcu (in C:\Program Files (x86)\Embarcadero\Studio\22.0\lib\win64\release and win64\debug and win32\release and win32\debug) and Data.DbxFirebird.pas (in C:\Program Files (x86)\Embarcadero\Studio\22.0\source\data\dbx) in my RAD Studio Folder (Enterprise Version).

from dbx4fb.

Hello Chee Yang Chau,

Is there Data.DbxFirebird.dcu in the RAD Studio folder? I am not quite sure if it is only available in Enterprise version and beyond.

No, infortunately, Data.DbxFirebird .dcu and .pas is completely absent in the current Delphi Professional 11.3
It seems that EMB deleted it definitively.

But, when I tested the same code you advise, with :

Prg_DBXInterBase.zip

C.DriverName := 'Interbase';
C.GetDriverFunc := 'getSQLDriverInterbase';

Then it connect (with dbx4fb.dll your last commits)

The Question, now is : can we use this dbx4fb.dll on Interbase Driver with FireBird 2.5 ?
No problem with Transactions ?

Thx...

from dbx4fb.

I just tested version 4.1.2023.62 in debug mode (RAD Studio 11.3, C++, Win64).
I get:

from dbx4fb.

I just tested version 4.1.2023.62 in debug mode (RAD Studio 11.3, C++, Win64). I get:

Can you try this: #7 (comment)

from dbx4fb.

Hello Chee Yang Chau,

Is there Data.DbxFirebird.dcu in the RAD Studio folder? I am not quite sure if it is only available in Enterprise version and beyond.

No, infortunately, Data.DbxFirebird .dcu and .pas is completely absent in the current Delphi Professional 11.3 It seems that EMB deleted it definitively.

But, when I tested the same code you advise, with :

Prg_DBXInterBase.zip

C.DriverName := 'Interbase'; C.GetDriverFunc := 'getSQLDriverInterbase';

Then it connect (with dbx4fb.dll your last commits)

The Question, now is : can we use this dbx4fb.dll on Interbase Driver with FireBird 2.5 ? No problem with Transactions ?

Thx...

Yes, You can use dbx4fb.dll for Firebird 2.5. You can find the list of of firebird distribution I perform the test here

from dbx4fb.

Yes, You can use dbx4fb.dll for Firebird 2.5.

Thank you Chee Yang Chau,
And sorry if i take your time.

I reformulate my question :
• Is it safe to go with "interbase" :

C.DriverName := 'Interbase'; C.GetDriverFunc := 'getSQLDriverInterbase

Instead of "Firebird" ?

• No problem in compatibility ?
• No problem with Transactions ?

If it can be problem, i will stay with an old dbx4fb.dll version in production with my Delphi 11.3 Pro.

Thx.

from dbx4fb.

@moyzer . I can't be sure about this: Is it safe to go with "interbase"

However, you may try run the testcases with the interbase settings you want and see if it fit to your needs.

from dbx4fb.

I just tested version 4.1.2023.62 in debug mode (RAD Studio 11.3, C++, Win64). I get:

Can you try this: #7 (comment)

No - does not work for me.
4.1.2022.58 works - if I replace it with 4.1.2022.62 I get still the mentioned error.

I am using fbclient.dll version 3.0.10.33601.

(Sorry for late reply)

from dbx4fb.

from dbx4fb.