download fbembed.dll lazarus / 16-Databases ---------------------------------------------------------------------- calm_sea · 2023-01-03 10:32 Good morning. I'm using lazarus with firebird 4 on win64. I can't find the fbembed.dll library for single seater installs. Where can I download fbembed.dll ? ---------------------------------------------------------------------- rvk · 2023-01-03 10:57 Quote from: calm_sea on January 03, 2023, 11:32:23 amGood morning. I'm using lazarus with firebird 4 on win64. I can't find the fbembed.dll library for single seater installs. Where can I download fbembed.dll ? You can't. Firebird 4 doesn't have a single fbembed.dll. You can use the complete install as embedded version. See https://ib- aid.com/download/docs/fb4migrationguide.html#_installing_embedded for the actual needed files. So use the fbclient.dll as your embedded client dll. ---------------------------------------------------------------------- Nicole · 2023-01-03 16:40 btw: Does anybody know, when the version of IBX may be available, which supports FB 4? ---------------------------------------------------------------------- rvk · 2023-01-03 17:57 Quote from: Nicole on January 03, 2023, 05:40:16 pmbtw: Does anybody know, when the version of IBX may be available, which supports FB 4? What makes you think the latest version doesn't support FB 4? This has already been discussed with you multiple times. ---------------------------------------------------------------------- Nicole · 2023-01-05 17:13 Why I thought this? Because of this site: https://www.mwasoftware.co.uk/ibx and this sentence Code: Text  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i The Firebird Relational Database Management System can be downloaded from http://www.firebirdsql.org. Version 2 (IBX2) provides full support for both the legacy Firebird API and the new Firebird 3 API. Do you use FB 4 and IBX 2.5? Will it work? Somebody say, that there may be a new release with about starting 2023. ---------------------------------------------------------------------- Thaddy · 2023-01-05 17:18 If you write embedded it can in my opinion never be a dll or so for that matter. Hence my disgust at such constructions. Embedded means fully self-contained and only needs one executable with everything - apart from the OS - linked in. Drop that Firebird shit: it lies to you. It is not in any way embedded. It introcuces a dependency to your code. So it is not embedded. All stops when you use a dynamically linked dependency other than from the OS.. ---------------------------------------------------------------------- domasz · 2023-01-05 17:24 Quote from: Thaddy on January 05, 2023, 06:18:55 pmDrop that Firebird shit: it lies to you. It is not in any way embedded. I agree but is there any embedded SQL database for FPC? ---------------------------------------------------------------------- Thaddy · 2023-01-05 17:26 Quote from: domasz on January 05, 2023, 06:24:20 pmQuote from: Thaddy on January 05, 2023, 06:18:55 pmDrop that Firebird shit: it lies to you. It is not in any way embedded. I agree but is there any embedded SQL database for FPC? Multiple, but I would recommend staticcaly linked Sqlite3. Instructions can be found on this forum or on the mORMot website. ---------------------------------------------------------------------- rvk · 2023-01-05 17:40 Quote from: Nicole on January 05, 2023, 06:13:44 pmWhy I thought this? Because of this site: https://www.mwasoftware.co.uk/ibx and this sentence QuoteThe Firebird Relational Database Management System can be downloaded from http://www.firebirdsql.org. Version 2 (IBX2) provides full support for both the legacy Firebird API and the new Firebird 3 API. Do you use FB 4 and IBX 2.5? Will it work? Somebody say, that there may be a new release with about starting 2023. Below is a post from juli 2021 from tonyw !! So IBX already supported 4.0 way back then. Quote from: tonyw on July 08, 2021, 11:15:05 amMWA Software is pleased to announce the release of version 2.4.1 of IBX for Lazarus. This is a maintenance release that fixes a problem with using Firebird 4.0.0. The fix for this problem has already been published in the SVN Repository. All users should upgrade to this version.  It is available for download from https://www.mwasoftware.co.uk/ibx ---------------------------------------------------------------------- Nicole · 2023-01-05 18:03 Nicole checks the manual again and found - oh yes!!! Very excited, - and - busy. *upgrading to FB 4* Thank you so much for the hint. ---------------------------------------------------------------------- Thaddy · 2023-01-05 18:12 Still leaves the same problem Rik, it is not embedded. ---------------------------------------------------------------------- rvk · 2023-01-05 18:33 Quote from: Thaddy on January 05, 2023, 07:12:03 pmStill leaves the same problem Rik, it is not embedded. Which isn't a problem for either TS or Nicole. ---------------------------------------------------------------------- domasz · 2023-01-05 20:17 Quote from: Thaddy on January 05, 2023, 06:26:25 pm Multiple, but I would recommend staticcaly linked Sqlite3. Instructions can be found on this forum or on the mORMot website. Interesting, it's a solution but honestly rather poor one. Still I won't be able to just compile my code for a different OS or architecture. ---------------------------------------------------------------------- zoltanleo · 2023-01-06 06:57 Quote from: calm_sea on January 03, 2023, 11:32:23 amGood morning. I'm using lazarus with firebird 4 on win64. I can't find the fbembed.dll library for single seater installs. Where can I download fbembed.dll ? rvk is right. Firebird does not have a separate library since version 3. Now it depends on the connection string. For example, to use a full- fledged server, do: Code: Pascal  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i SQL>connect '192.168.1.1/3051:/interdata/example.fdb' -user 'SYSDBA' -password 'masterkey'; But such a connection string will be used for the embedded server: Code: Pascal  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i SQL>connect '/interdata/example.fdb' -user 'SYSDBA' -password 'anypass'; See more https://wiki.freepascal.org/Firebird#Connection_examples ---------------------------------------------------------------------- Nicole · 2023-01-06 15:10 Do you like to try this? https://lazarus.intern.es/firebird_embedded.html This is German, what should not matter. The link points on a list of files, which shall be copied into the very directory, which should work as "embedded". ---------------------------------------------------------------------- calm_sea · 2023-01-21 12:05 thanks everyone for the replies. I still haven't solved it because I can't correctly configure the parameters for IBConnection. I leave the host name empty, set database, but it doesn't seem to find the libraries. I don't see any properties for the library path, nor a protocol property. I am using windows at moment. ---------------------------------------------------------------------- rvk · 2023-01-21 12:13 Quote from: calm_sea on January 21, 2023, 01:05:48 pm(...) but it doesn't seem to find the libraries. I don't see any properties for the library path, nor a protocol property. I am using windows at moment. And where did you put contents of the .zip of the entire Firebird database Engine? I.e. where did you put the fbclient.dll? Embedded you want them in your exe directory. Installed the installer will put a fbclient.dll in the correct windows directory so it is found automatically. ---------------------------------------------------------------------- calm_sea · 2023-01-21 16:15 I have the FB files in the exe directory. Now the error is "DoInternalConnect: -Unable to complete request to host "xnet://Global\FIREBIRD". I've been searching the web for similar problems, but nothing yet. I beleave xnet.. has to be local ... ---------------------------------------------------------------------- Jurassic Pork · 2023-01-21 16:29 hello, in your app folder, you must put also the plugins and intl directories (with their files) of the firebird installation files. Friendly, J.P ---------------------------------------------------------------------- calm_sea · 2023-01-21 17:07 Thank you! Now the compiled exe works! But it still doesn't work if I want to set connected=true in the inspector of the Lazarus ide (I removed the Firebird server to make sure I was only using embedded). Anyway I can reinstall the server now ---------------------------------------------------------------------- Nicole · 2023-01-21 20:33 the "connected=true", - do you use IBX? This can be a little bit tricky when to set and how. I tried a lot and more options and combinations than I can list here. In my case it was just a case of sooner or later and design time or runtime. ---------------------------------------------------------------------- rvk · 2023-01-21 23:07 Quote from: calm_sea on January 21, 2023, 06:07:47 pmThank you! Now the compiled exe works! But it still doesn't work if I want to set connected=true in the inspector of the Lazarus ide (I removed the Firebird server to make sure I was only using embedded). Anyway I can reinstall the server now You can't use embedded directly in the IDE. For that you would also need to copy all the embedded files to the lazarus.exe directory. (don't do that  ). Embedded only works with the dll in the exe directory and when setting connected to true in the IDE it's effectively the IDE which makes the connection (not your .exe). So if you are using Firebird in the IDE and in your program you are better off installing the server and test your program in Windows sandbox with only embedded files once its done. And during development you use your local server (you can still leave the hostname empty). ---------------------------------------------------------------------- calm_sea · 2023-01-22 09:58 ok, now everything is clear. thanks a lot to all of you