Using MyODBC to Connect to a Remote Database
(Page 1 of 6 )
Using MySQL's support for MyODBC, you can connect to remote databases, import and export tables to and from your MySQL database and more. In this article Steve shows us exactly how to get started...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.
Next: Why Connect Using MyODBC? >>
More MySQL Articles
More By Steve Knoblock
