Open Database Connectivity (ODBC) is a standard database access method that allows you to access and modify data from any application, regardless of which database management system is handling the data.
To add a MyODBC data source:
MyODBC data source options |
|
Option |
Description |
Data Source Name (DSN) |
The name used by your script to connect to the source database. |
ODBC Driver Name |
MySQL ODBC (MyODBC) Driver is the default driver. |
DSN Description |
The description of the data source. |
Host/Server Name (or IP) |
The host name or IP Address of the server on which the MySQL database is located. Its default value is localhost, that is, the server on which the site is currently hosted. |
Database Name |
The name of the MySQL database that you want to use as the default database. |
User |
The login name required to access the database. |
Password |
The password required to access the database. Note: This option is displayed only while adding a new MyODBC data source or changing the configuration of an existing one. |
Port |
The port number used to access the server on which the MySQL database is located. By default, MySQL uses port 3306 to service requests. Note: This field accepts port numbers only from 0 to 99999. |