DA Firebird Connection String via FireDAC

Data Abstract
1

I set up my first DA server to access Firebird using FireDAC. No matter what I tried to put in the Additional Params, the Firebird client library could not be located. My best guess was VendorLib=C:\FB25\WOW64\fbclient.dll;

This is the 32-bit version. It still reported that it couldn’t find fbclient. I dumped a copy into the RO directory where the DASchemaModeler7.exe lives, and the problem went away. But I would prefer not to make copies of this file all over my hard drive.

Anyone know the proper syntax to have the DA Connection be able to see the client library?

2

you can’t specify VendorLib via connection string but you can create Driver configuration file as described in this article: http://docs.embarcadero.com/products/rad_studio/firedac/Configuring_Drivers.html

3

It would sure be nice to specify it in the connection string. It would save
a step. In my desktop apps I just add a connection param

4

at this moment, some problems with this feature are present.

as a workaround, you can create FDDrivers.ini like

[FB21]
; FB21 virtual driver will use specified Firebird client library
BaseDriverID=FB
VendorLibWin32=C:\ib\fb21\bin\fbclient.dll
VendorLibWin64=C:\ib\fb21_64\bin\fbclient.dll

and ship it with your .exe or just put fbclient.dll near to your .exe.

5

I will do the first, because 1) I don’t need to make copies of these files,
and 2) it allows 32 and 64 bit apps to run side by side.

Дякую за відповідь

6

I tired putting a FDDrivers.ini file in the same directory as my RO Data
Abstract server. That didn’t work. So I put a copy of the FDDrivers.ini
file in the same directory as the Schema Modeler exe. That didn’t work. So
I put I edited the FDDrivers.ini in C:\Users\Public\Public
Documents\Embarcadero\Studio\FireDAC. That didn’t work. So I tried making
copies of these files as ADDrivers.ini, just in case RO/DA is looking for
the old name. That didn’t work. I even put [FB21] and [FB25] sections, just
to make sure it wasn’t looking for Firebird 2.1.

I have been unable to get the schema modeler to “see” my 32-bit Firebird
client library via the FDDrivers.ini file. So I’m back to putting a copy of
the client library in the exe location.

But that gets me to a new problem I discovered. When I switch my RO/DA
server to the 64-bit platform – my executable overwrites my 32-bit exe.
All my other Delphi apps create separate folder structures for 32-bit and
64-bit binaries. Why does RO output all binaries to the same folder? I
suspect it’s not an RO issue. It must be some new directive that tells
Delphi to create parallel output folders for 32-bit and 64-bit. I’ll
research that now. Still getting used to the post 64-bit Delphi world…

7

pls check that output folder for this project is set as .\$(Platform)\$(Config)

8

That’s the magic I was looking for, thanks for your quick reply