Owner's manual

Table 4 MXODSN and ODBCDSN attributes (continued)
DescriptionAttributesFile Section
seconds. SQLIntervalBehaviour
has two values, SYSTEM_DEFAULT and
MSDN_DEFAULT. If not specified, the
default is SYSTEM_DEFAULT. For more
information, see “SQL Interval
Behaviour property” (page 46).
SQLDatetimeRetrieval specifies
how the SQL/MP Datetime data type
SQLDatetimeRetrieval
is retrieved from the driver.
SQLDatetimeRetrieval has two
values, SYSTEM_DEFAULT and
MSDN_DEFAULT. If not specified, the
default is SYSTEM_DEFAULT. For more
information, see “SQL Datetime
Retrieval property” (page 48).
SQL_ATTR_CONNECTION_TIMEOUT
indicates the wait time to close an idle
SQL_ATTR _CONNECTION
_TIMEOUT
connection. If set to SYSTEM_DEFAULT,
the value is 60 seconds. If set to -1, use
the ConnTimeout value set on the
MXCS server data source. If set to
NO_TIMEOUT, the driver waits until a
ODBC server becomes available or
MXCS is stopped.
SQL_LOGIN_TIMEOUT indicates the
wait time to establish a connection with
SQL_LOGIN _TIMEOUT
MXCS. If set to SYSTEM_DEFAULT, the
value is 60 seconds. If set to
NO_TIMEOUT, the driver waits until a
connection is established with MXCS.
SQL_QUERY_TIMEOUT indicates the
wait time to close the cursor and return
SQL_QUERY _TIMEOUT
control to the ODBC application. If set
to SYSTEM_DEFAULT, the value is 60
seconds. If set to NO_TIMEOUT, the
driver waits till the query completes.
Catalog indicates the catalog name.
If not specified, the driver uses the
MXCS defined catalog name.
Catalog
Schema indicates the schema name. If
not specified, the driver uses the MXCS
defined schema name.
Schema
The values for AutoCommit can be
SERVER_DEFAULT, ON, and OFF. For
AUTOCOMMIT
more information, see “Managing
transactions” (page 34).
List of drivers.
This value must match the driver name
defined by DataSourceName attribute
in the [ODBC Data Sources] section.
Driver = driver[DataSourceName]
The following sample MXODSN file 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.
32 Configuring data sources