To configure a DSN on Mac OS X you should use the ODBC Administrator. If you have Mac OS X 10.2 or earlier, refer to Section 25.1.3.4, “Configuring a Connector/ODBC DSN on Unix”. Select whether you want to create a User DSN or a System DSN. If you want to add a System DSN, you may need to authenticate with the system. You must click the padlock and enter a user and password with administrator privileges.
-
Open the ODBC Administrator from the
Utilitiesfolder in theApplicationsfolder.
On the User DSN or System DSN panel, click
Select the Connector/ODBC driver and click .
-
You will be presented with the
Data Source Namedialog. Enter TheData Source Nameand an optionalDescriptionfor the DSN.
Click to add a new keyword/value pair to the panel. You should configure at least four pairs to specify the
server,username,passwordanddatabaseconnection parameters. See Section 25.1.3.5, “Connector/ODBC Connection Parameters”.Click to add the DSN to the list of configured data source names.
A completed DSN configuration may look like this:
You can configure additional ODBC options to your DSN by adding further keyword/value pairs and setting the corresponding values. See Section 25.1.3.5, “Connector/ODBC Connection Parameters”.
User Comments
When configuring the driver for use by any users of this computer (System User) I had to first go to the Drivers tab and seklect System from the drop down menu. Then go back to the System tab
Add your own comment.