MX 3.x)

Configuring Client Data Source Attributes for

ODBC/MX Connectivity

HP NonStop Open System Services ODBC/MX Client Driver—640328-001

2-2

Configuring Data Sources

The ODBCDSN file contains all the data sources and their configuration details. The

ODBCDSN file is an edit file and all the configuration details are maintained as a set of

predefined attributes or parameters.

The file can be located in the local directory of the application program, or alternatively

one system definition can be located in the system default location

$SYSTEM.SYSTEM.ODBCDSN (The OSS name is /G/system/system/odbcdsn).

You must search the ODBCDSN file in the same location as that of the application. If

you do not find the file, search for it in the $SYSTEM.SYSTEM location.

1. Edit the ODBCDSN file. The ODBCDSN file is installed in the $SYSTEM.SYSTEM

subvolume. Change the ODBCDSN file so that the attributes are set to the correct

values for your system (for example, names of data sources and attributes

describing them).

To use ODBC/MX data sources, the data source name in the ODBCDSN file must

exactly match the data source name defined in the ODBC/MX service (data source

names are case-sensitive).

If the CATALOG and SCHEMA attributes are not defined in the ODBCDSN file,

ODBC/MX uses the default values.

For details on attributes and settings in the ODBCDSN file, see Table 2-1, Format

of the ODBCDSN file, on page 2-3 and, Example ODBCDSN file on page 2-7.

2. Move the ODBCDSN file to the $SYSTEM.SYSTEM folder.

The OSS ODBC/MX driver first searches for the ODBCDSN file in the same OSS

directory as the executable file of the process. If the ODBCDSN file is not

available, the driver searches for it in $SYSTEM.SYSTEM.

You can also save the ODBCDSN in the OSS location where the executable

program is to be run. If you save the ODBCDSN file in the OSS location, it will take

precedence over the ODBCDSN available at the $SYSTEM.SYSTEM location.