Ah.. be careful what you wish for...
Microsoft's SQL when configured in a client-server environment requires that ALL network connections be ROCK SOLID. Even a good wireless network does not meet this criteria, as frequently the wireless connections are renegotiated "behind the scenes", dropping the connections to the SQL database. Lytec uses this, and it's maddening, as their program does not recover from lost connections to the SQL server, requiring that the program be stopped from the task manager and restarted, loosing any work that was on the screen when the connection went down.
I do not know if MySQL has this problem. Given a choice, I prefer MySQL for other reasons.. but that's just me.
I'm hoping before committing TOO many resources to the conversion off of Microsoft Jet, that they test for this and plan on being fault-tolerant of it.
Regards,
V.
