How to connect ISAPI module with Firebird

[JamesC]

I am trying to create ISAPI module with Apache, but get database connection error.

[FireDAC][Phys][FB]-314. Cannot load vender library [fbclient.dll or fbembed.dll]. The specified module could not be found.

fbclient.dll needs to be copied to folder \Apache24\bin

Directory of C:\Apache24\htdocs

06/01/20  15:18         1,381,376 fbclient.dll
05/10/17  21:35            16,177 firebird.log
21/04/20  13:51            13,819 index.html
06/08/20  20:27         6,210,048 MobISAPI.dll

Program code is shown below. If it is compiled as VCL Standalone program, it can be run properly.

type
  TMainmForm = class(TUnimForm)
    tabMain: TUnimTabPanel;
    tabStock: TUnimTabSheet;
    dsrT001: TDataSource;
    dbgT001: TUnimDBGrid;
    btnTest: TUnimButton;
    FDMoniFlatFileClientLink1: TFDMoniFlatFileClientLink;
    guixWaitCursor: TFDGUIxWaitCursor;
    tblT001: TFDTable;
    dbcMain: TFDConnection;
    procedure UnimFormCreate(Sender: TObject);
    procedure btnTestClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

procedure TMainmForm.UnimFormCreate(Sender: TObject);
begin
  with dbcMain.Params do begin
    Database := 'MYDBALIAS';
    UserName := 'sysdba';
    Password := 'xxxxxx';
  end;
  dbcMain.Connected := True;

  with tblT001 do begin
    TableName := 'T001';
    Active := True;
  end;
end;

My environment:

Windows 7 Ultimate

Delphi 10.2

uniGUI 1.90.0.1530 Trial

Apache 2.4

 

Thanks.

 

<Update>

Did some more search in Google, I found the problem and solved this problem.

To share with others:

fbclient.dll needs to be copied to folder \Apache24\bin

 

Edited August 6, 2020 by JamesC
Found solution