Open System Services ODBC/MX Client Driver for SQL/MX Release 3.2 (H06.25+, J06.14+)

Table 2 -1 describes the format of the ODBCDSN file. (continued)
Contents and FormatFile Section
SQL_ATTR _CONNECTION
_TIMEOUT
• Number of seconds the driver waits
in an active connection with no
exchange of data before closing the
connection
• SYSTEM_DEFAULT = 60
• NO_TIMEOUT (driver waits until a
server becomes available or
ODBC/MX is stopped)
SQL_LOGIN _TIMEOUT
• Number of seconds the driver will
wait to establish a connection with
the ODBC/MX Server
• SYSTEM_DEFAULT = 60
• NO_TIMEOUT
SQL_QUERY _TIMEOUT
• Number of seconds the driver waits
before closing the cursor and
returning control to the client.
• SYSTEM_DEFAULT = 0
• NO_TIMEOUT (driver waits until
query completes)
Name of the catalog to be used. If not
specified, the value is taken from those
defined by the ODBC/MX service.
CATALOG
Name of the schema to be used. If not
specified, the value is taken from those
defined by the ODBC/MX service.
SCHEMAFile Section
List of drivers. Currently, only one
driver can be used.
[DataSourceName]
The driver name for each data source
defined by DataSourceName in
[ODBC Data Sources] must match the
driver name defined by Driver in
[DataSourceName].
Example ODBCDSN file
The following example shows an ODBCDSN file that defines connections to three client data
sources, TDM_Default_DataSource, DS1, and DS2.
In this example, the attributes Catalog and Schema for data source DS1 are defined as DS1CAT
and DS1SCH.
[ODBC]
TraceFlags = 6
TraceStart = 0
TraceFile = trlog
[ODBC Data Sources]
TDM_Default_DataSource = NonStop ODBC/MX 3.x
DS1 = NonStop ODBC/MX 3.x
DS2 = NonStop ODBC/MX 3.x
DataSourceName = Driver
Configuring Data Sources 27