Problems with MS Access and MyODBC
Pasi Valkeila <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
Hello!
I have a VB6 program (haven´t written it myself) that uses an access2000
compatible database as a customer register. I have to change the
database so that it will use the customer register from a mysql
database. Database has about 4800 customers. I have configured the
database to export the customer table from a mysql using the myodbc 3.51
driver (File->Get External Data->Link Tables), and it works fine for a
moment, but after a while the vb6 program crashes. When I try handling
the mySQL table again with MS Access it pops up "ODBC --call failed.
(...) MySQL server has gone away (#2006)"
I´m not able to change the VB6 code nor the mySQL server settings.
Does this have something to do with keeping the connection alive or what
("wait-timeout")? MySQL server is 4.1.20-log.
Thanks
-Pasi, Finland
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/[email protected]