Creating and configuring a DSN on Mac OS X
The Mac OS X environment has a GUI interface for creating and configuring an Informix® ODBC data source name (DSN). This utility is the ODBC Administrator.
Procedure
To create and configure an Informix® DSN
on Mac OS X:
- Open the ODBC Administrator by choosing .
- Click the System DSN tab.
- Click Add.
- Select HCL Informix® ODBC Driver, and click OK.
- Enter a name in the Data Source Name field.
- Optional: Enter information in the Description field if you want to include it.
- Click Add.
- Click Key, which
appears directly under the Keyword column heading.A single click here enables you to edit the field in this row.
- Type UID in the field so that it overwrites Key.
- Click Value on the right side of the row, which appears directly under the Value column heading so that you can edit the field.
- Type in the name of the login user that is used to connect to the database.
- Repeat steps 7 and 9 to create three more row entries
so that all the Keyword-Value pairs correspond with the entries in
the following table. Enter the real information of your system in
place of the variables in the Value column of the following table.
Keyword Value UID your_login_user PWD password_of_login_user Database your_database ServerName your_server_name - Click OK.
- Edit the global sqlhosts file to specify
server connectivity information for Informix® ODBC
data sources.This file is at /etc/InformixODBC/sqlhosts. The following is an example of a line entry in the sqlhosts file:
odbc_demo onsoctcp clipper turbo csm=(SPWDCSM)
The fields in this line define the following connectivity parameters:- Column 1 (
odbc_demo
in the example): server name (this should be identical to ServerName defined in the DSN) - Column 2 (
onsoctcp
as example): connection protocol - Column 3 (
clipper
as example): host name (a local computer must end in.local
) - Column 4 (
turbo
as example): service name (as defined inetc/services
) or port number - Column 5 (
csm=SPWDCSM
as example): optional connection setting, such as an Informix® communications support moduleNote: Support for Communication Support Module (CSM) is removed starting Informix Server 14.10.xC9 . You should use Transport Layer Security (TLS)/Secure Sockets Layer (SSL) instead.
See the Informix® Administrator's Guide for details on how to set up the sqlhosts file.
- Column 1 (