What happens when the mSQL server goes down between requests?
If the mSQL database server process, msqld, dies and is subsequently restarted, or the host on which it was running is rebooted, any processes that were connected to the mSQL database server MUST be reconnected. This is not unique to mSQL, the Oracle database server behaves in a similar manner. Programs that were connected to the mSQL database server should be either restarted or have some internal mechanism whereby they notice the server has died and attempt a reconnection. One possible method for checking the status of the database server would be to examine the return status of the msqlSelectDB() call.