Create an ODBC DSN for a MySQL Database

Feature Data Objects API

 
Create an ODBC DSN for a MySQL Database
 
 
 

Do the following:

  1. On the Windows Start menu, click Settings, click Control Panel, click Administrative Tools, click Data Sources (ODBC). The ODBC Data Source Administrator dialog box is displayed.
  2. In the ODBC Data Source Administrator dialog box, click the User DNS tab if you want the data source to be visible only to you on this machine, or click the System DSN tab if you want the data source to be visible to others on this machine and on the network. Click Add. The Create New Data Source dialog box is displayed.
    NoteYou may not use the File DSN tab, because Fdo does not support its use.
  3. In the Create New Data Source dialog box, click MySQL ODBC 3.51 Driver, click Finish. The Connector/ODBC 3.51.12 dialog box is displayed.
  4. In this dialog box, in the text entry box labeled Data Source Name , type the name that you want to use as the value of the DataSourceName connection property.
  5. In this dialog in the text entry box labeled Server, type the hostname/IP address of the machine where the MySQL database server is installed. The default is localhost.
  6. You can ignore text entry boxes labeled User and Password. You provide that information using the Fdo UserId and Password connection properties.
  7. Pick a database using the drop-down combination box labeled Database.
  8. Click OK to close the Configuration dialog.
  9. In the ODBC Data Source Administrator dialog box, you see the DSN that you just added listed. Click OK.