7.2 testers-thread

The forum for ZeosLib 7.2 Report problems. Ask for help, post proposals for the new version and Zeoslib 7.2 features here. This is a forum that will be edited once the 7.2.x version goes into RC/stable!!

My personal intention for 7.2 is to speed up the internals as optimal a possible for all IDE's. Hope you can help?! Have fun with testing 7.2
Locked
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, all

Zeos7.2-beta branches_ testing_Revision 3428 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90) - CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).


Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.392 2014-10-24 13:25:32 from:
http://synopse.info/fossil/info/a068f60 ... f39fb96515
Delphi XE2-32 localhost and remote.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.8.7.

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

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

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist,

R_3432:
[DCC Error] ZDbcInterbase6Utils.pas(1468): E2003 Undeclared identifier: 'isc_portable_integer'

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

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, all

Zeos7.2-beta branches_ testing_Revision 3433 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90) - CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).


Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.413 2014-10-27 15:21:47 from:
http://synopse.info/fossil/info/0d4110c ... d9cf4f6abd
Delphi XE2-32 localhost and remote.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.8.7.

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

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

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, all

Zeos7.2-beta branches_ testing_Revision 3437 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90) - CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10dev) - CodeTyphon ver 5.10 rebuilt without a problem. v4.5.0.1436 -Win-32/64-bit build with success,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).


Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.433 2014-10-29 08:09:25 from:
http://synopse.info/fossil/info/228976b ... 588aef0cec
Delphi XE2-32 localhost and remote.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.8.7.

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

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

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist,

R 3459
Error in Fedora 20-64 and CT4.80:

Code: Select all

/usr/lib/codetyphon/typhon/components/pl_ZeosDBO/source/dbc/ZDbcMySqlStatement.pas(1798,37) Error: Can't determine which overloaded function to call
/usr/lib/codetyphon/typhon/components/pl_ZeosDBO/source/dbc/ZDbcMySqlStatement.pas(2161) Fatal: There were 1 errors compiling module, stopping


1798:          Length := Min(MaxLobSize, Max(MYSQL_FIELD^.length,
1799:            MYSQL_FIELD^.max_length))+Ord(SpaceForTrailingNull);
Michal
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, all

Zeos7.2-beta branches_ testing_Revision 3461 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90) - CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10) - CodeTyphon ver 5.10 rebuilt without a problem. LazSqlX 4.5.0.1436 -Win-32/64-bit build with success,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).


Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.458 2014-11-02 08:18:36 from:
http://synopse.info/fossil/info/6e1bc87 ... 88e0d7e1da
Delphi XE2-32 localhost and remote.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, MariaDB 10.1, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.8.7.

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

Michal
Michl
Fresh Boarder
Fresh Boarder
Posts: 13
Joined: 01.04.2014, 12:53

Re: 7.2-Beta testers-thread

Post by Michl »

I would try the last Zeos-trunc r3467, with Win7 64bit, Lazarus 1.3 r46752M FPC 2.7.1 r28983 32bit. I got a compiler-error: ZDbcAdo.pas(61,60) Fatal: Kann Unit ZPlainAdoDriver nicht finden verwendet von ZDbcAdo von Package zdbc. (I tryed to compile this unit - without a postive result)

I tryed some other trunc-versions of Zeos, the error comes with r3467. All tested revisions are compilable without errors, also r3466.
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, all

Zeos7.2-beta branches_ testing_Revision 3467 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),

- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - Compiles after correction packages - ADO operates on Windows,,

- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90) - CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success- ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10) - CodeTyphon ver 5.10 rebuilt without a problem. LazSqlX 4.5.0.1436 -Win-32/64-bit build with success -
ADO operates on Windows,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).


Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.467 2014-11-03 from:
http://synopse.info/fossil/info/66c5abe ... 72cf72fedb
Delphi XE2-32 localhost and remote.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, MariaDB 10.1, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.8.7, NEW: Firebird 3.0 Beta 1

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

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

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, all

Zeos7.2-beta branches_ testing_Revision 3469 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/

Now - Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - ADO operates on Windows.

Bravo Michael.

Michal
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Re: 7.2-Beta testers-thread

Post by EgonHugeist »

Thanks Michal for testing!

@all
i've been trying to support CodeTyphoon as good as possible. PL did allow us to use the Windows-OleDb.pas unit of CodeTyphoon. ADO is now available for FPC+Windows too.
All my ADO tests are passing with FPC too except Tests where double/floating-point values are used. TDateTime is out of that rule.
I do not get an exception on trying to access the OleVariants with such values, i can't read the types and values it's selves, simply nothing happens, just the results are always 0.0! Weird.
In addition FPC misses the VUInt64 field and VarType. So such values are NOT accessable too.

I would be happy if someone could raise a bugreport on FPC-bugtracker. I do not have the time for it... :prog2:

Also did we make deep tests with MariaDB-10 and FireBird 3.0-Beta. Hope you read Michals tests carefully?! You safely can use these new servers too. Note FB3.0 provides some more features but not all of them are handled by Zeos actually except the true BOOLEAN field.

Additional notes: since we are in Beta i can't ad more features. For me latest changes are handled as bug-fixes (e.g. CodeTyphoon got a loads of reports for ADO which are handled now)

Have fun!
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, all

Zeos7.2-beta branches_ testing_Revision 3470 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90) - CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success- ADO operates on Windows
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10) - CodeTyphon ver 5.10 rebuilt without a problem. LazSqlX 4.5.0.1436 -Win-32/64-bit build with success -
ADO operates on Windows,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).


Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.468 2014-11-05 09:53:38 from:
http://synopse.info/fossil/info/2cbcb18 ... 65987a7691
Delphi XE2-32 localhost and remote.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, NEW: MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, NEW: Firebird 3.0 Beta 1.

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

Michal
woec
Fresh Boarder
Fresh Boarder
Posts: 13
Joined: 23.04.2013, 20:47

Re: 7.2-Beta testers-thread

Post by woec »

Hi,

I tried to configure ADO protocol for my MS SQL Server Database connection. But ADO protocol ist not in the list to select from.
I use zeos-7.2.0-beta-r3472 and lazarus 1.2.6 on win7/32
Are there any additional steps to prepare this protocol type?

regards
Johann
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Re: 7.2-Beta testers-thread

Post by EgonHugeist »

@woec,

sure you made a !fresh! compile of zeos? No old files(Z*pas,Z*.ppu etc) available? IT should work (on Windows only of course)
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-Beta testers-thread

Post by miab3 »

@woec,

See attach.
ADO_Lazarus126-W64.png
Michal
You do not have the required permissions to view the files attached to this post.
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, all

Zeos7.2-beta branches_ testing_Revision 3477 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90) - CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success- ADO operates on Windows
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10) - CodeTyphon ver 5.10 rebuilt without a problem. LazSqlX 4.5.0.1436 -Win-32/64-bit build with success -
ADO operates on Windows,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).


Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.477 2014-11-07 09:31:43 from:
http://synopse.info/fossil/info/37f0517 ... e21e800b75
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, NEW: MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, NEW: Firebird 3.0 Beta 1.

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

Michal
Locked