Page 10 of 12
Re: ZeosLib 7.1 testers-thread
Posted: 16.09.2013, 19:28
by miab3
@EgonHugeist, @mdaems,
Zeos7.1.1-rc-(beta) branches_ testing_R2737:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Michal
Re: ZeosLib 7.1 testers-thread
Posted: 17.09.2013, 12:09
by miab3
@EgonHugeist, @mdaems,
Zeos7.1.1-rc-(beta) branches_ testing_R2739:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Michal
Re: ZeosLib 7.1 testers-thread
Posted: 19.09.2013, 11:05
by miab3
@EgonHugeist, @mdaems,
Zeos7.1.1-rc-(beta) branches_ testing_R2742:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Michal
Re: ZeosLib 7.1 testers-thread
Posted: 26.09.2013, 12:19
by miab3
@EgonHugeist, @mdaems,
Zeos7.1.1-rc-(beta) branches_ testing_R2751:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Michal
Re: ZeosLib 7.1 testers-thread
Posted: 27.09.2013, 23:21
by miab3
@EgonHugeist, @mdaems,
Zeos7.1.1-rc-(beta) branches_ testing_R2761:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
It can be regarded as stable?!
Michal
Re: ZeosLib 7.1 testers-thread
Posted: 29.09.2013, 20:58
by miab3
@EgonHugeist, @mdaems,
After the 2660 patch appeared error:
Invalid objes name 'syslanguages​​'
for Zconnection.Open in mssql and FreeTDS.
Michal
Re: ZeosLib 7.1 testers-thread
Posted: 29.09.2013, 21:49
by EgonHugeist
Grumble, i have no such issues, Michal. I can connect fine with my MSSQL 2012.
Any proposal to find a soution to get the dateformat determination running with SQL Server2000 -> 2012?
Re: ZeosLib 7.1 testers-thread
Posted: 29.09.2013, 21:53
by miab3
@EgonHugeist,
For me, appears on the Microsoft SQL Server 2008 R2 Express 64-bit.
Michal
Re: ZeosLib 7.1 testers-thread
Posted: 29.09.2013, 22:08
by EgonHugeist
Hope i got a smarter solution by checking if table_owner "SYS" exists or not...
Patch done R2768 \testing 7.1
Can you test it?
Re: ZeosLib 7.1 testers-thread
Posted: 29.09.2013, 22:21
by miab3
@EgonHugeist,
http://solihinho.wordpress.com/category ... rver/page/2/
http://msdn.microsoft.com/en-us/library/ms187997.aspx
In MSSQL 2012 syslanguages ~ sys.syslanguages ->Compatibility view
It may?:
Code: Select all
try
RS := Stmt.ExecuteQuery('SELECT dateformat FROM sys.syslanguages WHERE name = @@LANGUAGE');
except
RS := Stmt.ExecuteQuery('SELECT dateformat FROM syslanguages WHERE name = @@LANGUAGE');
end;
Michal
Re: ZeosLib 7.1 testers-thread
Posted: 29.09.2013, 22:35
by miab3
@EgonHugeist,
Patch R2768 also works.
Michal
Re: ZeosLib 7.1 testers-thread
Posted: 29.09.2013, 22:39
by miab3
@EgonHugeist, @mdaems,
Zeos7.1.1-rc-(beta) branches_ testing_R2768:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
It can be regarded as stable?!
Michal
Re: ZeosLib 7.1 testers-thread
Posted: 02.10.2013, 08:13
by serbod
svn://svn.code.sf.net/p/zeoslib/code-0 (commit number 2772)
ZAbstractDataset.pas: 524
Code: Select all
BM := Bookmark; // cause type error in FPC 2.6.3
if BookmarkValid({$IFDEF WITH_TBOOKMARK}BM{$ELSE}@BM{$ENDIF}) Then
begin
InternalGotoBookmark({$IFDEF WITH_TBOOKMARK}BM{$ELSE}@BM{$ENDIF});
Resync([rmExact, rmCenter]);
end;
DisableControls;
InternalSort;
BookMark:=BM;
db.pas in FPC 2.6.3
TDataSet.Bookmark: TBookmarkStr // not TBookmark !
Re: ZeosLib 7.1 testers-thread
Posted: 02.10.2013, 19:28
by EgonHugeist
@serbod
2.6.3 is work in progress AFAIK. I also noticed this issue. We can simply fix it by undefine WITH_TBOOKMARK
BUT doing this means we're going back to the old pre 2.6- TDataset support. Which realy is NOT what we want. I think there was something going terribly wrong on merging there branches for 2.6.3. This is not a Zeos issue further more a huge FPC bug. Please raise a ticket on th FPC bugtracker, i had not the time to do that.
@miab3
Yes it can declared as stable if we fully resolve this syslanguages issue of MSSQL. Did commit a new patch. Can you test it?
Re: ZeosLib 7.1 testers-thread
Posted: 02.10.2013, 20:09
by miab3
@EgonHugeist, @mdaems,
Zeos7.1.1-rc-(beta) branches_ testing_R2778:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
I've test new patch it works with MSSQL 2005/2008 Express.
It can be declared as stable!
Michal