Zeos 7.3 testers-thread

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
af0815
Fresh Boarder
Fresh Boarder
Posts: 18
Joined: 24.03.2017, 12:49

Re: Zeos 7.3 testers-thread

Post by af0815 »

Actual Zeos trunk wont compile sucessfully in Linux enviorment.
ZDbcOleDB need ActiveX. This is not available on Linux (Debian).

See http://forum.lazarus.freepascal.org/ind ... #msg291460

Andreas

Edit: ENABLE_OLEDB is IMHO false activated in ZDbcOleDB.pas. It should not activated in Linux - see ZEOS.onc line 408.
miab3
Zeos Test Team
Zeos Test Team
Posts: 1309
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

@af0815,

Code: Select all

// Enables ADO support in TZConnection/TZDataset
{$IF not defined(ZEOS_DISABLE_ADO) and defined(MSWINDOWS)}
  {$DEFINE ENABLE_ADO}
{$IFEND}
...
// Enables OleDB support in TZConnection/TZDataset
{$IF not defined(ZEOS_DISABLE_OLEDB) and defined(MSWINDOWS)}
  {$DEFINE ENABLE_OLEDB}
{$IFEND}
in zeos.inc should exclude from compilation in Linux ADO and OLEDB.

In ZDbcOleDB.pas (Line 58) there is an error, it should be:
{.$DEFINE ENABLE_OLEDB}

Michal
tkamphuis
Junior Boarder
Junior Boarder
Posts: 30
Joined: 18.01.2009, 09:20
Contact:

Re: Zeos 7.3 testers-thread

Post by tkamphuis »

I have a problem in 7.3 build 4742

Windows 10
Lazarus 1.8.4
You do not have the required permissions to view the files attached to this post.
miab3
Zeos Test Team
Zeos Test Team
Posts: 1309
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

ZEOS 7.3 svn 4746 Delphi 2007:
[DCC Error] ZDbcStatement.pas(6397): E2033 Types of actual and formal var parameters must be identical
[DCC Error] ZDbcODBCResultSet.pas(65): F2063 Could not compile used unit '..\..\src\dbc\ZDbcStatement.pas'

Line 6397: FExecStatements[FCallExecKind].GetDateTime(ParameterIndex, Result.VDateTime);

Michal
miab3
Zeos Test Team
Zeos Test Team
Posts: 1309
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

@EgonHugeist, @Jan, @Fr0sT, @mdaems, All

ZEOS 7.3.x svn 4768:

http://sourceforge.net/p/zeoslib/code-0 ... sting-7.3/

compiles and run on:

- Lazarus 1.8.4-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Delphi 2007-Win32 (Windows 10-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64).

Tested: SQLite, Firebird, Oracle, PostgreSQL, mySQL, MariaDB, MSSQL(ADO, OLE DB, ODBC, FreeTDS), Access.
mORMot 1.18.4640 - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).

Michal
miab3
Zeos Test Team
Zeos Test Team
Posts: 1309
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

@EgonHugeist, @Jan, @Fr0sT, @mdaems, All

ZEOS 7.3.x svn 4772:

http://sourceforge.net/p/zeoslib/code-0 ... sting-7.3/

compiles and run on:

- Lazarus 1.8.4-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Delphi 2007-Win32 (Windows 10-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64).

Tested: SQLite, Firebird, Oracle, PostgreSQL, mySQL, MariaDB, MSSQL(ADO, OLE DB, ODBC, FreeTDS), Access.
mORMot 1.18.4640 - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).

Michal
miab3
Zeos Test Team
Zeos Test Team
Posts: 1309
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

@EgonHugeist, @Jan, @Fr0sT, @mdaems, All

ZEOS 7.3.x svn 4790:

http://sourceforge.net/p/zeoslib/code-0 ... sting-7.3/

compiles and run on:

- Lazarus 1.8.4-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Delphi 2007-Win32 (Windows 10-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64).

Tested: SQLite, Firebird, Oracle, PostgreSQL, MySQL, MariaDB, MSSQL(ADO, OLE DB, ODBC, FreeTDS), Access.
mORMot 1.18.4640 - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).

Michal
miab3
Zeos Test Team
Zeos Test Team
Posts: 1309
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

@EgonHugeist, @Jan, @Fr0sT, @mdaems, All

ZEOS 7.3.x svn 4835:

http://sourceforge.net/p/zeoslib/code-0 ... sting-7.3/

compiles and run on:

- Lazarus 1.8.4-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Delphi 2007-Win32 (Windows 10-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64).

Tested: SQLite, Firebird, Oracle, PostgreSQL, MySQL, MariaDB, MSSQL(ADO, OLE DB, ODBC, FreeTDS), Access.
mORMot 1.18.4640 - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).

Michal
Fr0sT
Zeos Dev Team
Zeos Dev Team
Posts: 280
Joined: 08.05.2014, 12:08

Re: Zeos 7.3 testers-thread

Post by Fr0sT »

Weird. I have several test fails with 4835 (even app crash on TestArrayBindings) on Delphi XE2 and even more fails on Lazarus 1.9.0.
miab3
Zeos Test Team
Zeos Test Team
Posts: 1309
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

@EgonHugeist, @Jan, @Fr0sT, @mdaems, All

ZEOS 7.3.x svn 4888:

http://sourceforge.net/p/zeoslib/code-0 ... sting-7.3/

compiles and run on:

- Lazarus 1.8.4-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Delphi 2007-Win32 (Windows 10-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64).

Tested: SQLite, Firebird, Oracle, PostgreSQL, MySQL, MariaDB, MSSQL(ADO, OLE DB, ODBC, FreeTDS), Access.
mORMot 1.18.4719 - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).

Michal
miab3
Zeos Test Team
Zeos Test Team
Posts: 1309
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

@EgonHugeist, @Jan, @Fr0sT, @mdaems, All

ZEOS 7.3.x svn 4981:

http://sourceforge.net/p/zeoslib/code-0 ... sting-7.3/

compiles and run on:

- Lazarus 1.8.4-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Delphi 2007-Win32 (Windows 10-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64).

Tested: SQLite, Firebird, Oracle, PostgreSQL, MySQL, MariaDB, MSSQL(ADO, OLE DB, ODBC, FreeTDS), Access.
mORMot 1.18.4719 - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).

Michal
miab3
Zeos Test Team
Zeos Test Team
Posts: 1309
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

@EgonHugeist, @Jan, @Fr0sT, @mdaems, All

ZEOS 7.3.x svn 5040:

http://sourceforge.net/p/zeoslib/code-0 ... sting-7.3/

compiles and run on:

- Lazarus 1.8.4-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Delphi 2007-Win32 (Windows 10-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64).

Tested: SQLite, Firebird, Oracle, PostgreSQL, MySQL, MariaDB, MSSQL(ADO, OLE DB, ODBC, FreeTDS), Access.
mORMot 1.18.4719 - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).

Michal
Zoran
Senior Boarder
Senior Boarder
Posts: 55
Joined: 07.05.2010, 22:32

Re: Zeos 7.3 testers-thread

Post by Zoran »

Compilation is broken in Lazarus on Linux (and other non-windows targets).
I use 7.2-patches branch and the bug is introduced there in 5034, when recent changes from 7.3 got merged there.

I installed 7.3 and I see the bug is introduced there on 17. august (rev. 4956). I created the ticket -- https://sourceforge.net/p/zeoslib/tickets/299/

Can I ask at least not to merge to 7.2 without testing on Linux. 7.2-patches is supposed to be most stable branch.
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1918
Joined: 17.01.2011, 14:17

Re: Zeos 7.3 testers-thread

Post by marsupilami »

Hello Zoran,

for me Zeos 7.2 compiles without a problem on Linux x86_64. The same goes for Zeos 7.3 which gets compiled on Linux and Windows automatically by a Jenkins instance. As of today Zeos 7.2 gets compiled and tested automatically there too. Please put the error messages you get in the bugtracker too.

Bets regards,

Jan
Zoran
Senior Boarder
Senior Boarder
Posts: 55
Joined: 07.05.2010, 22:32

Re: Zeos 7.3 testers-thread

Post by Zoran »

marsupilami wrote:Hello Zoran,

for me Zeos 7.2 compiles without a problem on Linux x86_64. The same goes for Zeos 7.3 which gets compiled on Linux and Windows automatically by a Jenkins instance. As of today Zeos 7.2 gets compiled and tested automatically there too. Please put the error messages you get in the bugtracker too.

Bets regards,

Jan
Sorry. I copied the message to the bugtracker now.

And it is:
ZPlainAdoDriver.pas(76,33) Fatal: Cannot find Windows used by ZPlainAdoDriver of package zplain.
Post Reply