I'm using Delphi 7, ZEOS 6 components, connects to MySQL server. I create a simple project with ZConnection and ZTable, put one button wich just do ZTable.Refresh. When I run prog its connecting to server, I push button for table refresh - all ok. Now just set system time to 2 days later - push button again - its give me a error. Any operations with table, query gives me a error after date change (but need to increase date - decrease no error). If I reconnects to server after date chage - all ok but in my project I can't reconnect. Its bug or maybee I can do something with this. Please help
What's the error you get?
Where do you change system date? Server or client?
Ever tried to do that while connected using the mysql console (mysql.exe).
Why can't you reconnect in your project? You could try to add a Connection.PingServer call before the refresh.
Mark
I get 'Access violation read of address x00000' or sometime 'Lost connection to MySQL during query'. I have a server and client running on same PC. The same thing happens with time change but backwards and for long time period. My project needs to work all time - if I will reconnect I need to stop all work and than reconnect.
I also try to do the same in MyCC (MySQL Control Center). When I run query after change date in Windows - [locserv] ERROR 2013: Lost connection to MySQL server during query. As I see its MySQL server error. Its very bad bug I think. :-(
Probably not a bug. In fact it's you who's causing an unexpected environment change for the server.... Try the (new) PingServer and Reconnect Connection methods before Refresh (or other database actions). Good chance it works.
