MX Release 3.2.1 (H06.26+, J06.15+)

2 Configuring Client Data Source Attributes for ODBC/MX

Connectivity

This chapter includes these sections:

• “Accessing the ODBC/MX Data Source” (page 24)

• “Configuring Data Sources” (page 24)

• “Adding New Data Sources” (page 29)

• “Modifying Data Sources” (page 29)

• “Removing Data Sources” (page 29)

• “Tracing OSS ODBC/MX Client Driver” (page 29)

• “Components of the MX Connectivity Service” (page 30)

• “Migration Considerations” (page 30)

• “Accessing the ODBCDSN file through environment variable” (page 30)

Use the MXCS configuration to add, configure, and remove ODBC/MX data sources.

Accessing the ODBC/MX Data Source

To configure the ODBC/MX data source use the following commands:

TACL > osh > mxci > mode mxcs

The following example describes how the data source is accessed from the TACL prompt:

TACL> osh

/usr/tandem:

/usr/tandem: mxci

Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.3 (c)

>>mode mxcs;

CS>

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 OSS local directory of the application program, or alternatively, it

can be located in the system default location, $SYSTEM.SYSTEM.ODBCDSN (The OSS name is

/G/system/system/odbcdsn).

You can find the ODBCDSN file in the same OSS location as that of the application. If it is not

found in this location, look for the ODBCDSN file in $SYSTEM.SYSTEM.

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 (NONSTOP_SYSTEM_NSK for the CATALOG).

24 Configuring Client Data Source Attributes for ODBC/MX Connectivity