DevShed: MySQL and ODBC

By ServerWatch Staff (Send Email)
Posted Feb 18, 2001


"Although creating custom Web-based GUIs (Graphical User Interfaces) for your MySQL backend is a fairly common method for administrating database information, it is not without its problems. Slow Internet connections and cross-browser coding issues are just a few issues that could inhibit your client from updating their database information in the most timely and efficient way possible. Of course, problems such as these are largely out of your control, but don't try telling that to the client!"

"Well, if not a Web-based GUI, what then? The alternative is actually a quite interesting one. You may not be aware that MySQL is compatible with the ODBC (Open DataBase Connectivity) standard, and even offers its own ODBC drivers (known as MyODBC) free for download from the MySQL site (http://www.mysql.com). This is great, because MyODBC makes it possible to incorporate MySQL into quite a few interesting applications, including Microsoft Access. In this article, I'll demonstrate just how easy it is to install and configure MyODBC and subsequently use Microsoft Access to manage MySQL data." You may not be aware that MySQL is compatible with the ODBC (Open DataBase Connectivity) standard, and even offers its own ODBC drivers (known as MyODBC) free for download from the MySQL site (http://www.mysql.com). This is great, because MyODBC makes it possible to incorporate MySQL into quite a few interesting applications, including Microsoft Access. In this article, I'll demonstrate just how easy it is to install and configure MyODBC and subsequently use Microsoft Access to manage MySQL data.

Page 1 of 1


Comment and Contribute

Your name/nickname

Your email

(Maximum characters: 1200). You have characters left.