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

Configuring Client Data Source Attributes for
ODBC/MX Connectivity
HP NonStop Open System Services ODBC/MX Client Driver—544990-002
2-4
ODBCDSN File Format
FetchBufferSize Size of buffer used to fetch rows
•
Range: 0 to 256 Kb
•
SYSTEM_DEFAULT = 8Kb
•
Single row = 0
(use to get update on current operation
or when exercising Publish/Subscribe)
[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
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
File Section Contents and Format