Problem with Firebird using Lazarus 2.0.8
lazarus / 16-Databases

----------------------------------------------------------------------
Neville · 2020-06-22 14:45

Using TSQLConnector, I can login to a firebird database and query a
table in the IDE during development, but when I run the program  I get
an exception "Cannot locate fbclient.dll etc  "

I don't understand why the dlls can be found by the ide during
development, but can't be found by the program when it runs.

Can anyone offer any suggestions.

Thanks,  Neville

----------------------------------------------------------------------
eljo · 2020-06-22 15:03

Where on disk are the dlls? Any antivirus that gets in the way?

----------------------------------------------------------------------
Neville · 2020-06-22 15:17

The dlls are in both system32 and sysWOW64.

----------------------------------------------------------------------
eljo · 2020-06-22 16:18

Quote from: Neville on June 22, 2020, 05:17:53 pmThe dlls are in both
system32 and sysWOW64.
This should work for all programs. I have left only the antivirus
idea. Just to make sure check that no firebird dlls are in the same
directory as lazarus.exe file before starting disabling/uninstalling
antivirus.

----------------------------------------------------------------------
valdir.marcos · 2020-06-22 16:43

Quote from: Neville on June 22, 2020, 04:45:36 pmUsing TSQLConnector,
I can login to a firebird database and query a table in the IDE during
development, but when I run the program  I get an exception "Cannot
locate fbclient.dll etc  "
I don't understand why the dlls can be found by the ide during
development, but can't be found by the program when it runs.
Can anyone offer any suggestions.
Thanks,  NevilleYou can always put "fbclient.dll" in the same folder
of your program.
Remember that both must be of same bitness: both 32bit or both 64bit.

----------------------------------------------------------------------
Neville · 2020-06-22 17:00

Thanks, that's useful.

----------------------------------------------------------------------
Neville · 2020-06-23 15:18

Thank you, getting the bitness sorted the problem.

I've found very little help (on the system) to be able to confirm the
bitness of an exe or dll, so I've written a short program to display
the bitness.

----------------------------------------------------------------------
lucamar · 2020-06-23 15:54

Quote from: Neville on June 23, 2020, 05:18:29 pmso I've written a
short program to display the bitness.
Would you mind sharing it? And, is it (or can be made) cross-platform?

----------------------------------------------------------------------
eljo · 2020-06-23 16:34

Quote from: lucamar on June 23, 2020, 05:54:30 pmQuote from: Neville
on June 23, 2020, 05:18:29 pmso I've written a short program to
display the bitness.
Would you mind sharing it? And, is it (or can be made) cross-platform?
the best tool for the job I know of https://ntcore.com/?page_id=388

----------------------------------------------------------------------
emilt · 2020-06-29 14:11

There is also Sigcheck from Sysinternals:
https://docs.microsoft.com/en-us/sysinternals/downloads/sigcheck

----------------------------------------------------------------------
mangakissa · 2020-06-30 12:29

use TSQLDBLibraryLoader

----------------------------------------------------------------------
balazsszekely · 2020-07-16 11:42

Quote from: lucamar on June 23, 2020, 05:54:30 pmQuote from: Neville
on June 23, 2020, 05:18:29 pmso I've written a short program to
display the bitness.
Would you mind sharing it? And, is it (or can be made) cross-platform?
Windows only: https://wiki.freepascal.org/Multiplatform_Programming_Gu
ide#Detecting_bitness_of_external_library_before_loading_it