Lazarus/FPC and Zeos lib on Linux boxes

[otalado]

I have Lazarus 2.2.3/FPC 3.2.3 and Zeos lib zcomponentdesign 8.0 installed on several boxes: PC (x64) Windows 11 Pro (Bullseye), PC (x64) Debian 11 (Bullseye), Raspberry Pi 4 (AArch64) Debian Bullseye, Raspberry Pi 4 (AArch32) Debian Buster.

I encountered an issue on all the Linux boxes: I placed the ZConnection on the form, filled the Database with the SQLite database path, LibraryLocation with sqlite3 path (/usr/bin/sqlite3), choose the SQLite in Protocol. When I tried to check theConnected an error was triggered: zconnection System Error,(OS CODE 22) invalid argument. In a setup like that Windows box worked OK.

So my questions are:
- is this a known issue for Lazarus/Zeos on Linux boxes?
If so:
- are there any ways to work around this issue?
If not:
- are there any special considerations (that I am not aware of) that I need to follow when installing the Zeos on Linux Lazarus/FPC combo?

[marsupilami]

Hello otalado

I encountered an issue on all the Linux boxes: I placed the ZConnection on the form, filled the Database with the SQLite database path, LibraryLocation with sqlite3 path (/usr/bin/sqlite3),

This might be the problem. /usr/bin/sqlite3 is the sqlite2 interactive sql application, not the database access library. You need something like libsqlite3.so. On my Debian 11 computer it is /usr/lib/x86_64-linux-gnu/libsqlite3.so.0.

So my questions are:
- is this a known issue for Lazarus/Zeos on Linux boxes?

No - there isn't.

are there any special considerations (that I am not aware of) that I need to follow when installing the Zeos on Linux Lazarus/FPC combo?

Yes - officially we don't support development versions of Lazarus and FPC. So your mileage might vary. Please stick to the stable versions, if possible.

[otalado]

Hi, marsupilami,
I found the reason myself just before I checked if there were any responses to my query. I guess that was a kind of stupid mistake to make. In my defense, I am on Linux only a month or so, and on FPC/Lazarus just about four afternoons. So considered scattered often hopelessly cryptic info/docs it is no wonder that I am still disoriented and prone to stupid mistakes like that.
As to your advice about using the stable version I totally agree. I first went with the testing branch because FPCUpDeluxe suggested '(testing branch => seems the most reliable)', and because the stable version gave me grief while compiling it. I realized that can be due to the fact that my FPC/Lazarus versions were not stable too.
I 'downgraded' one of my boxes to a stable version of FPS/Lazarus and when I tried to install the stable Zeos package I was successful. So one of the next afternoons I'll do it on all other boxes.
I guess using C++ and a framework would be a more logical path for a multiplatform project, but at my ripe age, I don't feel like starting to learn such a 'monster' language ...

[otalado]

Sorry, that was very rude of me. On my previous post, I forgot to tell you that I am (of course) grateful for your help and suggestions. That needs to be told because a helping hand is always appreciated...

[marsupilami]

Hello otalando,

my advice for development with FPC, Lazarus and Zeos is to install FPC and Lazarus using FPCUpDeluxe. Then checkout the latest Zeos 8.0 from our SVN - because we don't have a download for Zeos 8.0 yet. This should give you the best experience.

Regarding Zeos and fpcupdeluxe: It is hard to find out who distributes (possibly outdated) Zeos versions and even harder to get this fixed, if necessary.

And finally regarding C++: I don't think C++ gives you an advantage. Lazarus is a good tool for cross platform development. The LCL is widely compaible to the Delphi VCL, FPC and Lazarus are available for a lot of platforms. I see no reason to use C++

Best regards,

Jan