Creating and configuring a DSN on Mac OS X
The Mac OS X environment has a GUI interface for creating and configuring an HCL® OneDB® ODBC data source name (DSN). This utility is the ODBC Administrator.
Procedure
To create and configure an HCL
OneDB DSN
on Mac OS X:
- Open the ODBC Administrator by choosing Applications > Utilities > ODBC Administrator.
- Click the System DSN tab.
- Click Add.
- Select HCL OneDB 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 HCL
OneDB 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 HCL OneDB communications support module
See the HCL OneDB Administrator's Guide for details on how to set up the sqlhosts file.
- Column 1 (