Zeos for Lazarus is officially ported!

[Stevie]

Hi everyone,

the port to lazarus is done - fpc now has full support for variants and interfaces. Because the port is not "much more" than "a few" compiler directives, therefore the functionality is the same as it is on delphi or kylix. The sources you can get from the cvs on http://sourceforge.net/projects/zeoslib/

Regards,
Stevie

[Anonymous]

Could you give a little bit detailed download and build instructions ?

[Vincent Snijders]

Stevie, may I suggest you create a zip with the needed sources and lazarus package? I think it would be great to have this component on Lazarus Code and Components page and available for download at the Lazarus CCR Files page.

[hombergs]

@ Stevie:
I reported a Patch for FPC/Lazarus under linux.
Cause there are some functions missing.
And I reported a bug.
Cause under Linux the Firebird and SQLite driver will raise a range check error when you set the Connected propertie of the TZConnection to true.
This will only happen when yyou set the propertie in  the IDE to true for testing.

@Guest:
You need a CVS client for getting this great piece of software.
If you use Windows then try TortoiseCVS.
The CVS server is: cvs.sourceforge.net
Username: anonymous
Repository Path: /cvsroot/zeoslib
No password.
Checkout the zeosdbo_rework (this is the actual Zeos).
After checking out install the components in the following order:
zcore.lpk
zparsesql.lpk
zplain.lpk
zdbc.lpk
zcomponent.lpk

[Vincent Snijders]

I did some browsing through the cvs and have some questions/suggestions/remarks.

The zcomponent package has a absolute path to the include files:
<IncludeFiles Value="E:\Programme\Lazarus\components\zeos\src\component\"/>

If I understand the lazarus pacakge system correctly, the zcore, zparsesql, zplain and the zdbc package can be a runtime package only, because they don't install any components. Of course other packages can use it, and it still will be included in the lazarus executable.

[Stevie]

@hombergs: I must confess that I only tested the windows version of Lazarus but this was only the first step. I try to setup a linux-system for testing and look for it, thanks!

@vincent: Yes, you are right, but in the past the delphi-packages of zeos had to be installed too (I changed this already) I still am not very familiar with Lazarus but a few weeks ago I was not able to install only the component package without the others (maybe this behaviour changed? I will test this)

[Anonymous]

Thank you, I will try it. The "zeosdbo_rework" was the missing info. I tired checkout zeosdbo, but all files seems very old. The rework seems far better :-)

[hombergs]

@Stevie: I found the bug. FPC/Lazarus defines HMODULE as longint. But the dlopen function from libc returns sometimes a negative value. So I redifine HMODULE in ZCompatibility as longword now and it works. I uploaded a new patchfile. This include the changes that Vincent has suggested.

[Anonymous]

I tired to compile it, but I've got the following error messages:
Zeos.inc(42,2) Warning: Unsupported switch "$O"
Zeos.inc(44,2) Warning: Unsupported switch "$W"
Zeos.inc(42,2) Warning: Unsupported switch "$O"
Zeos.inc(44,2) Warning: Unsupported switch "$W"
Zeos.inc(42,2) Warning: Unsupported switch "$O"
Zeos.inc(44,2) Warning: Unsupported switch "$W"
Zeos.inc(42,2) Warning: Unsupported switch "$O"
Zeos.inc(44,2) Warning: Unsupported switch "$W"
/usr/lib/lazarus/zeos/src/plain/ZPlainLoader.pas(150,17) Error: Identifier not found "GetModuleHandle"
/usr/lib/lazarus/zeos/src/plain/ZPlainLoader.pas(154,19) Error: Identifier not found "HMODULE"
/usr/lib/lazarus/zeos/src/plain/ZPlainLoader.pas(181,5) Error: Identifier not found "FreeLibrary"
/usr/lib/lazarus/zeos/src/plain/ZPlainLoader.pas(181,24) Error: Illegal expression
/usr/lib/lazarus/zeos/src/plain/ZPlainLoader.pas(193,13) Error: Identifier not found "GetProcAddress"
/usr/lib/lazarus/zeos/src/plain/ZPlainLoader.pas(199) Fatal: There were 5 errors compiling module, stopping

The GetModuleHandle, etc seems WIN32 functions, I tired to compile it under linux (with the latest fpc binary snapshot).

[hombergs]

Please apply the patch from the zeos patch tracker.
The direct link to the patch is in my first post.
The attached file is the newest patch.
After applying the patch Zeos will compile under Linux without a problem.

[Stevie]

I added your changes into the actual sources a few minutes ago. Now it should be compilable on linux.

[jesusr]

I did a small test using the firebird 1.5 employee sample database,  it seems to have problems with some numeric fields? check for example the DEPARTMENT and SALARY_HISTORY tables, here is a link to the lazarus project: http://mx.geocities.com/jesusrmx/lazarus/zeos_fbbrowser.tgz

[Anonymous]

I'm sorry, but when I tired the compile it under linux, I've got the following messages:
/usr/lib/lazarus/zeos/src/core/ZCompatibility.pas(132,13) Hint: Type "HMODULE" redefinition
/usr/lib/lazarus/zeos/src/core/ZCompatibility.pas(190,21) Error: Identifier not found "dl"

[jesusr]

open ZCompatibility.pas and remove the "dl." prefix from each line that fails.

[Anonymous]

Thank you, it is work for me!