mysql odbc questions

i'd like to use the mysql odbc driver for connecting to my mysql database via my own app. the problem is that it seems very unstable - i keep getting errors like:

[MySQL][ODBC 5.1 Driver][mysqld-5.5.8]MySQL server has gone away

it seems to be something like a session timeout.

so here's my 开发者_JAVA技巧questions: - what is causing those errors? - is there a way to fix it for getting stable connections? - is it recommended at all using it for coding windows software?

thanks

---

My guess is you're opening the connection once and leaving it open. At some point, the connection either times out, or some network hiccup is causing the connection to be invalid/closed. The best way to do database access is to open the connection when you need to do work, then close it. Or, alternatively, change your code to support re-connecting when you encounter an error.

Based on discussion in the comments below, I would suggest dumping the access database to a csv file, then using something like PHPMySql to import the data into MySQL.

You can use the BigDump tool to import large databases dumps into MySQL. (via this site)

---

There are commercial alternatives out there -

OpenLink Single-tier ODBC Driver for MySQL