User`s guide

MySQL ODBC for Windows
2-59
3
Click the System DSN tab and then click Add. When setting up an ODBC data
source, you can use a User DSN or System DSN. A User DSN is specific to the user
on a machine. Any data sources a user defines under User DSN are seen only by that
specific user. Conversely, a System DSN is not specific to the user on a machine. Any
data sources a user defines under System DSN on a machine can be seen by any user
who logs into that machine. Your ability to set up a User DSN or System DSN might
depend on the database and ODBC driver you are using. For details, contact your
database administrator or your database ODBC driver documentation.
4
A list of installed ODBC drivers appears in the Create New Data Source dialog box.
Select the ODBC driver MySQL ODBC 5.2a Driver. Your ODBC driver might have
a different name. Click Finish.
5
In the MySQL Connector/ODBC Data Source Configuration dialog box, enter an
appropriate name for your data source in the Data Source Name field. You use
this name to establish a connection to your database. Here, enter MySQL as the data
source name. Enter a description for this data source, such as MySQL database,
in the Description field. Enter your database server name in the TCP/IP Server
field. Enter your port number in the Port field. The default port number is 3306.
Enter your user name in the User field. Enter your password in the Password field.