I've noticed that if I leave my server running from VB6 and leave it for a little while (usually after suspending my computer) and try to login I get the error message that the account doesn't exist. It seems that this line:
Code:
RS.Open "SELECT * FROM accounts WHERE `login`='" & cLogin & "';", Conn_Server, adOpenStatic, adLockReadOnly
Fails for some unknown reason and the AccountExist function terminates, leaving it defaulted to False, and so does not allow me to login. If I restart the server this problem disappears, and I have not had to restart the MyDQL instance to get it to work. any one have any clue why?