Page 1 of 1

SQL error : Lost connection to mysql server during query

Posted: 30.09.2008, 17:46
by pttk
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

Posted: 01.10.2008, 08:21
by mdaems
Looks like a remote database connection over a troubled network?

Posted: 01.10.2008, 15:37
by pttk
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"

Posted: 01.10.2008, 17:24
by pttk
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?

Posted: 01.10.2008, 19:19
by mdaems
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

Posted: 01.10.2008, 21:28
by pttk
Thank

I explore one solution.