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

3 Configuring data sources

This chapter describes the SQL/MX driver manager configuration. For details about unixODBC

driver manager configuration, see the unixODBC website: http://www.unixodbc.org.

This chapter describes the following:

• “Configuring client data sources” (page 17)

• “MXODSN file format” (page 17)

• “Managing data sources” (page 20)

• “Tracing” (page 20)

• “Setting the MXODSN file path in DSN_PATH” (page 21)

Configuring client data sources

The MXODSN file, which is a text file, is a repository of all client data sources.

You can place the MXODSN file in any one of the following locations:

• Location specified in DSN_PATH environment variable

• Linux ODBC application directory

• Default system location, /etc/hpodbc

To configure a client data source, edit the MXODSN file. Change this file so that the attributes are

set to the correct values for your system (for example, names of data sources and attributes

describing them).

The DSN in the MXODSN file must exactly match the server data source name (data source names

are case sensitive). If the data source names do not match, the application gets a warning that

connection is established with default data source, TDM_Default_DataSource.

The driver uses default values for CATALOG and SCHEMA attributes if you have not defined them

in the MXODSN file.

The search order for the MXODSN file is:

1. Location specified in DSN_PATH environment variable

2. Linux ODBC application directory

3. Default system location, /etc/hpodbc

Configuring driver for IPV6

To configure a Linux ODBC/MX driver for IPV6, you can directly enter the IPV6 address instead

of IPV4 address in the MXODSN or odbc.ini (when using unix driver manager) configuration

files. The ODBC/MX driver recognizes the IPV6 address format and connects to the server.

The following is a sample from the configuration file:

Server = TCP: 2620:0:a17:e03e:a00:8eff:fe08:cd65:3033

When using the domain name, it depends on how the name is resolved.

MXODSN file format

Table 3 (page 18) describes the MXODSN file sections and attributes.

Configuring client data sources 17