Appendix H: ODBC and .NET

Overview

MySQL can connect with languages or environments that do not have their own developed application programming interfaces (APIs) or drivers for interacting with MySQL via Open Database Connectivity (ODBC). ODBC is a widely used API for connecting and interacting with relational databases. It is database- and language-independent. With MySQL, it's commonly used to connect to tools such as Microsoft Access or Visual Basic. To do so, you'll need to install the MyODBC driver. This is available, along with full installation instructions, from the MySQL website (www.mysql.com/downloads/api-myodbc.html). Installing on Windows is a matter of downloading the executable file and running it.

This appendix explains how to set up a data source on Unix and Windows, explains how to export data from Microsoft Access to MySQL, serves as a reference to the MyODBC functions for experienced programmers, and provides simple example scripts for using ODBC to connect, insert, and select records with VB .NET, C# .NET, DOA, ADO, and RDO. This appendix is not a complete description of ODBC and how to use it. For more information, examine the ODBC documentation on the Microsoft site (www.microsoft.com/data/odbc/ ), the ODBC documentation that comes with your development environment, or the information on the MySQL site (www.mysql.com/products/myodbc/).



Mastering MySQL 4
Mastering MySQL 4
ISBN: 0782141625
EAN: 2147483647
Year: 2003
Pages: 230
Authors: Ian Gilfillan

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net