Error when I try to use v6.6.4 instead of v6.6.2 rc

VitOs2 · Post by **VitOs2** » 15.03.2009, 16:09

Hi, all!
At first, I want to thank authors for these components!
I have a project that work in this manner (simply):
Server - PostgreSQL 8.3
Client - Delphi 2007, ZConnection + ZReadOnlyQuer (or zQuery...).
Sometimes the connection between Server and Client is breaking. So, client needed for reconnect.
Here is a problem.
When I use ZeosDBO 6.6.2 rc the program process disconnection well. If connection dropped and I make some query for Server the connection is automatically getting up and application continue to work.
But, when I use ZeosDBO 6.6.4 stable version the client don't want work correct. ZConnection.Connected is always in true, but I can't do anything. Every query have exception like this:

Access violation at address 7C9109F9 in module 'ntdll.dll'. Read of address 000B00A3.

Procedure
ZConnection.Connectd := False; ZConnection.Connectd := True;
can't be realized. It always make exception.
And I can't close application correct to.

Can you explain (or fix) this problem. What I need to do? My application must work over the Internet which is not stable. So I need to treat all breakups correct.

Thank you!

Post by **seawolf** » 15.03.2009, 19:18

Recently, for Postgres, has been added the method "PingServer", which check if the connection between a client and a server is on.
So if a connection goes down property Zconnection.Connected is set to false.

Anyway I don't remember is that new method was added to Zeos 6.6.4 or you need to download and install an svn snapshot

VitOs2 · Post by **VitOs2** » 15.03.2009, 19:47

Thanks for reply. The meter is that I can't change state of Zconnection.Connected. When I try to assign True or False to Zconnection.Connected it makes exception.
After connection break ZConnection not response correct for any commands.
It is only in last version of components... In 6.6.2 the treatment of connecition break is well.

VitOs2 · Post by **VitOs2** » 16.03.2009, 12:59

Can anyone explain me, how can I infrom ZeosLib authors about this bug?

Post by **seawolf** » 16.03.2009, 19:00

The problem is the first attemp.

When you do a Zconnection.Connect for the first time it Zeos cannot connect to the server raise that error.

Anyway having an ntdll.dll exception it seems to me you have installed something which raise some conflict (i.e. a new postgres version) not related to Zeos.

If you want to contact Zeos Dev Team go to http://zeosbugs.firmos.at

VitOs2 · Post by **VitOs2** » 17.03.2009, 08:42

Thanks! But the main problem that it dosn't work good only in 6.6.4 version. In 6.6.2 all ok. So, I think, that the reason isn't in some other system complonents.
Ok, will be write to Zeos Dev Team.