ZeosLib 7.1 testers-thread

[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

[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

[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

[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

[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

[miab3]

@EgonHugeist, @mdaems,

After the 2660 patch appeared error:
Invalid objes name 'syslanguages​​'
for Zconnection.Open in mssql and FreeTDS.

Michal

[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?

[miab3]

@EgonHugeist,

For me, appears on the Microsoft SQL Server 2008 R2 Express 64-bit.

Michal

[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?

[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

[miab3]

@EgonHugeist,

Patch R2768 also works.

Michal

[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

[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 !

[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?

[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