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.