Open System Services ODBC/MX Client Driver (SQL/MX 3.x)

Configuring Client Data Source Attributes for
ODBC/MX Connectivity
HP NonStop Open System Services ODBC/MX Client Driver—640328-001
2-5
ODBCDSN File Format
[data-source-name]
continued
Data Source
Description
Description
Server
IP address or domain name where
ODBC/MX server is running, in the form:
TCP:number1/number2
Where:
number1 is IP address or domain name
number2 is port number
SQLFractionValue
If SQLFractionValue = 9, the fraction value
of SQL_C_TIMESTAMP variable is
considered to be nanoseconds.
If SQLFractionValue is not specified or if it
is SQL_DEFAULT or another value apart
from 9, the fraction part of
SQL_C_TIMESTAMP variables is
considered to be microseconds.
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 = 60
•
NO_TIMEOUT (driver waits until query
completes)
CATALOG
Name of the catalog to be used.
If not specified, the value is taken from
those defined by the ODBC/MX service.
Table 2-1. Format of the ODBCDSN file (page 3 of 4)
File Section Contents and Format