Using MyODBC to Connect to a Remote Database (Page 1 of 6 )
One of the impressive features of MySQL is its full support for ODBC (Open DataBase Connectivity). The source for the ODBC driver and interface are available for those interested in furthering open source development or customizing ODBC access. All ODBC 2.5 functions and many others are supported.
You may use Microsoft Access to connect to your MySQL server, which this tutorial is based on. MyODBC is the ODBC driver for the MySQL database server produced by TCX Data-Consult in Sweden. MySQL provides support for ODBC by means of the MyODBC program.
In this article I will show you exactly how to use MyODBC to connect to a remote database, perform data copying activities and more. I will assume that you have an intermediate knowledge of MySQL.