To configure a DSN on Mac OS X you can either use the
myodbc3i utility, edit the
odbc.ini
file within the
Library/ODBC
directory of the user or the
should use the ODBC Administrator. If you have Mac OS X 10.2 or
earlier, refer to
Section 22.1.4.5, “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.
For correct operation of ODBC Administrator, you should ensure
that the /Library/ODBC/odbc.ini
file used
to set up ODBC connectivity and DSNs are writable by the
admin
group. If this file is not writable by
this group then the ODBC Administrator may fail, or may appear
to have worked but not generated the correct entry.
There are known issues with the OS X ODBC Administrator and
Connector/ODBC that may prevent you from creating a DSN using
this method. In this case you should use the command-line or
edit the odbc.ini
file directly. Note
that existing DSNs or those that you create using the
myodbc3i or
myodbc-installer tool can still be checked
and edited using ODBC Administrator.
To create a DSN using the myodbc3i utility, you need only specify the DSN type and the DSN connection string. For example:
shell> myodbc3i -a -s -t"DSN=mydb;DRIVER=MySQL ODBC 3.51 Driver;SERVER=mysql;USER=username;PASSWORD=pass"
To use ODBC Administrator:
Open the ODBC Administrator from the
Utilities
folder in theApplications
folder.On the User DSN or System DSN panel, click
Select the Connector/ODBC driver and click
.You will be presented with the
Data Source Name
dialog. Enter TheData Source Name
and an optionalDescription
for the DSN.Click
to add a new keyword/value pair to the panel. You should configure at least four pairs to specify theserver
,username
,password
anddatabase
connection parameters. See Section 22.1.4.2, “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 other ODBC options in your DSN by adding further keyword/value pairs and setting the corresponding values. See Section 22.1.4.2, “Connector/ODBC Connection Parameters”.