SQL error : Lost connection to mysql server during query

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

pttk
Junior Boarder
Junior Boarder
Posts: 37
Joined: 24.03.2006, 15:07

SQL error : Lost connection to mysql server during query

Postby pttk » 30.09.2008, 17:46

Hi,

I use 6.6.0 ZeosLib with Delphi 7.0, but when pass any minutes : " Lost connection to mysql server during query"

Any idea?

PTTK
PTTK

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 01.10.2008, 08:21

Looks like a remote database connection over a troubled network?

pttk
Junior Boarder
Junior Boarder
Posts: 37
Joined: 24.03.2006, 15:07

Postby pttk » 01.10.2008, 15:37

Thank

When install my applications in localhost (same network) work ok, when use external host for MySQL send error : " Lost connection to mysql server during query"
PTTK

pttk
Junior Boarder
Junior Boarder
Posts: 37
Joined: 24.03.2006, 15:07

Postby pttk » 01.10.2008, 17:24

Hi,

I install 6.6.3 stable and send the same error " Lost connection to mysql server during query" when OPEN Query, back to menu and input again and OPEN work.

Timeout?
PTTK

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 01.10.2008, 19:19

Nope. Bad connection between client (=dll) and server. When the connection gets lost the library tries to connect again. That's why the second try succeeds. If this kind of shaky connections is normal in your environment (maybe some server timeout setting?) you better call ZConnection.Ping before taking actions that need the connection.

Mark
Image

pttk
Junior Boarder
Junior Boarder
Posts: 37
Joined: 24.03.2006, 15:07

Postby pttk » 01.10.2008, 21:28

Thank

I explore one solution.
PTTK


Return to “6.5.1 (alpha) - 6.6.x (beta)”

Who is online

Users browsing this forum: No registered users and 1 guest