Zeoslib Portal

Mark,



I installed version .102 (so with the patches) with zcomponent*.* from version .98.
Today, i gonna install the full version of .102 with the necessary changes.


Guy

Hi Mark, The issue is fixed. We did some tests yesterday and there were no more problems with the new version. Nevertheless, there are some changes (and problems) with the packages in version .102: ZComponent.dpk and ZComponentDesign.dpk. What is the reason? I installed the packages in this order: z...

Don't misunderstand me. ms sql server 2000 is still widely used in combination with dblib, because this was the standard protocol in the previous versions. And there are still patches for this version. Please don't stop support for dblib. Nevertheless, the latest versions of zeoslib don't work anymo...

Hi, Anyone who uses delphi 7/sql server 2005/ado/latest version zeoslib? Till now, we use delphi 7/sql server 2000/dblib/zeoslib 6.5.1 (nov 2004). Because you can't buy sql server 2000 any longer, we gonna upgrade to sql server 2005. This version doesn't support dblib, so we gonna use ado. Greetz, Guy

Anyone who is working with the latest version of zeoslib in combination with dblib (sql server 2000)? It does not work for me. A simple select crashes because zeos interpretes the tablename as a fieldname. As I said, we are still working with an old version (6.5.1 nov 2004). Here it works fine. We w...

Hi Mark, Heb eveneens getest met veldnamen in select. Probleem blijft. Heb gisteren ongeveer alle mogelijkheden getest, en krijg steeds dezelfde fout: de naam van de tabel wordt beschouwd als een veld. Heb een klein testproject gemaakt om snelheid te testen. Dit werkt prima met de versie van nov. 20...

Hi Terence,

We are using delphi 7 in combination with sqlserver 2000 (dblib).
'SELECT FIELD FROM TABLE' results in the same error.

Off course in our production environment, we never define a select like 'SELECT * FROM TABLE'.
I only wanted to compare the speed between the old and the newer version.

We use Zeoslib 6.5.1 (release nov. 2004) in our project. It works fine, except the speed (open query) is slow. I was currious about the newer version if it is faster. So, i installed it this morning. But with the latest versions (revison 66 and 79), we are unable to run a select. Test: Drop a connec...

Microsoft no longer support DBLIB in the latest version of SQL SERVER (2005).
You can only connect using ADO

Hello,

we did also some tests and came to the same conclusion.
'qry.open' is very slow with ZEOS.

Speed is significantly better with 'ADO' and 'SQLDirect'
Disabling the debug define in zeos.inc doesn't change anything.

Hi, We have a customer who uses a wireless laptop in combination with our application. Sometimes the connection is broken, and the program crashes. Is there a manner to resume the connection automatically without crashing the program? We are using delphi 7 sp 1, zeoslib 6.5.1, sql server 2000 sp4 an...

don't use recordcount (z.recordcount)!
It is slow.

In place create a function e.g. 'getRecCount(q: TZQuery): integer'

select statement: 'select count(*) from courses'

if you use ADO, you need mdac 2.x. (website microsoft)
if you use dbLIB (old driver SQLSERVER), you need ntwdblib.dll (search on the internet)

Both are supported by ZEOS.

dblib = protocol TZConnection = mssql
ado = protocol TZConnection = ado

do you have installed mdac?
for sqlserver you can use ado or dblib.
dblib is the old driver and is also included in mdac 2.x
you can install it from the microsoft site.

Thanks a lot!

gr.,

Guy