ZeosLib 7.1 testers-thread

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
miab3
Zeos Test Team
Zeos Test Team
Posts: 916
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 16.09.2013, 19:28

@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2737:
http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-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
Zeos Test Team
Zeos Test Team
Posts: 916
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 17.09.2013, 12:09

@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2739:
http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-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
Zeos Test Team
Zeos Test Team
Posts: 916
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 19.09.2013, 11:05

@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2742:
http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-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
Zeos Test Team
Zeos Test Team
Posts: 916
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 26.09.2013, 12:19

@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2751:
http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-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
Zeos Test Team
Zeos Test Team
Posts: 916
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 27.09.2013, 23:21

@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2761:
http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-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
Zeos Test Team
Zeos Test Team
Posts: 916
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 29.09.2013, 20:58

@EgonHugeist, @mdaems,

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

Michal

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1701
Joined: 31.03.2011, 22:38

Re: ZeosLib 7.1 testers-thread

Postby EgonHugeist » 29.09.2013, 21:49

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?
King regards, Michael

You want to help? 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: 916
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 29.09.2013, 21:53

@EgonHugeist,

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

Michal

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1701
Joined: 31.03.2011, 22:38

Re: ZeosLib 7.1 testers-thread

Postby EgonHugeist » 29.09.2013, 22:08

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?
King regards, Michael

You want to help? 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: 916
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 29.09.2013, 22:21

@EgonHugeist,

http://solihinho.wordpress.com/category/sql-server/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
Last edited by miab3 on 29.09.2013, 22:37, edited 1 time in total.

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

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 29.09.2013, 22:35

@EgonHugeist,

Patch R2768 also works.

Michal

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

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 29.09.2013, 22:39

@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2768:
http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-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
Fresh Boarder
Fresh Boarder
Posts: 20
Joined: 27.12.2012, 09:31

Re: ZeosLib 7.1 testers-thread

Postby serbod » 02.10.2013, 08:13

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 !

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1701
Joined: 31.03.2011, 22:38

Re: ZeosLib 7.1 testers-thread

Postby EgonHugeist » 02.10.2013, 19:28

@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?
King regards, Michael

You want to help? 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: 916
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 02.10.2013, 20:09

@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2778:
http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-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


Return to “ZeosLib 7.1 stable Forum”

Who is online

Users browsing this forum: No registered users and 1 guest