Chris LeFebvre wrote:

> One thing, my application is 64bit and I do have the 64bit
> fbclient.dll in the Debug / application so can you connect to an
> embedded database at design time by checking the Connected property
> of the TFDConnection component? I remember reading somewhere that
> during design time that since the IDE is 32bit that in certain
> instances there may be a bitness problem between design time and run
> time? But regardless of if it’s designed time or run time I still get “Database unavailable”?

1. Only one application can be connected to a particular database with an
embedded connection. So, if your Delphi project is still open
when you try to run your executable, you will get "Database
unavailable" in your executable. (If you are running a database
tool such as isql or FlameRobin that's connected to that database,
the problem is the same).

2. Those guys on the idera forum have got it wrong. In Firebird 3,
(fbclient.dll + engine12.dll) are equivalent to fbembed.dll in the
older Fb versions. You DO NOT rename anything to fbembed.dll.

3. The VendorLib is fbclient.dll in both environments. The
bitness-appropriate DLL should be in the application directory, so if
the Delphi IDE really is still 32-bit then you need the 32-bit DLL at
design time, as fbclient.dll is where the API is implemented.

OTOH, if you compiled you executable as 64-bit, then it is is the
64-bit fbclient.dll you want in the application directory of your
executable. Engine12.dll (in the \plugins subdir beneath your
executable) is the Firebird database engine, through which your client
will connect to databases. It can be 32-bit or 64-bit on a 64-bit box
- your choice.

4. I think it's a mistake to try and do a custom Firebird install for
your early testing. Just unzip the whole thing and then go back later
and get rid of the pieces you don't need.

Helen


---
This email has been checked for viruses by AVG.
https://www.avg.com