IBM® Informix® Client Software Development Kit, Version 4.10

Configuring a DSN in Windows

In Windows environments, IBM® Informix® ODBC Driver provides a GUI to configure DSNs.

To configure a DSN:

For a description of values, see the following two tables. Values are shown in the order that they appear in each section. You can also use Microsoft ODBC, Version 2.5 or later, to configure a DSN.
Tip: To find out what DSN you have, click the About tab and read the contents of the Description text box.
Important: To configure a DSN on the Windows 64-bit platform, you must use the 32-bit ODBC Data Source Administrator:

If you are enabling single-sign on (SSO), additional steps are in "Configuring ESQL/C and ODBC Drivers for SSO" in IBM Informix Security Guide.

Table 1. Required DSN values
Required values Description
Data Source Name DSN to access

This value is any name that you choose. Data Source Name is like an envelope that contains all relevant connection information about the DSN.

Database Name Name of the database to which the DSN connects by default
Host Name Computer on which Server is in
Protocol Protocol used to communicate with Server

After you have added a DSN, the menu will display the available choices.

Server Name IBM Informix database server on which Database is in
Service IBM Informix database server process that runs on your Host computer

Confirm the service name with your system administrator or database administrator.

Table 2. Optional DSN values
Optional values Description
Client Locale Default value: en_us.1252
Database Locale Default value: en_us.1252
Description Any information, such as version number and service
Options General information, such as password settings

For more information about this value, see the sqlhosts information in your IBM Informix Administrator's Guide.

Password Password for access to the DSN
Translation Library Dynamic linked library (DLL) that performs code-set conversion; default value: $INFORMIXDIR\bin\ig04n304.dll
User ID User identification or account name for access to the DSN
Translation Option Option for a non-IBM Informix translation library

Varying multibyte character length reporting option that specifies how to set pcbValue when rgbValue (the output area) is not large enough for the code-set-converted data

Possible values:
  • 0=Estimate
  • 1=Exact

Default value: 0

Cursor Behavior Flag for cursor behavior when a commit or rollback transaction is called
Possible values are:
  • 0=close cursor
  • 1=preserve cursor

Default value: 0

After you complete these steps, you will connect to the DSN.

Send feedback | Examples exchange | Troubleshooting

To find the PDF, see Publications for the IBM Informix 12.10 family of products.
For the release notes, documentation notes, and/or machine notes, see the Release Notes page.
timestamp Release date: September 2013