SQL error : Lost connection to mysql server during query

pttk · Post by **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

Post by **mdaems** » 01.10.2008, 08:21

Looks like a remote database connection over a troubled network?

pttk · Post by **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 · Post by **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?

Post by **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

pttk · Post by **pttk** » 01.10.2008, 21:28

Thank

I explore one solution.