MX Release 3.2 (H06.25+, J06.14+)

Configuring Client Data Sources on Windows

HP NonStop ODBC/MX Driver for Windows—691126-003

3-3

Configuring Client Data Sources for Update

Operations

The following table lists the driver connection attributes:

Configuring Client Data Sources for Update

Operations

To perform “update . . . on the current of” operations:

Set the fetch buffer size to zero using the ODBC Cient Administrator. This forces

fetching one row at a time instead of a buffered fetch.

An error is returned if:



The SQL_ATTR_CONCURRENCY attribute is set to

SQL_CONCUR_READ_ONLY



The WHERE CURRENT OF clause is used in an UPDATE or DELETE statement.

Attribute Description

DSN Name of the data source as returned by

SQLDataSources API or the data

sources dialog box of SQLDriverConnect

API.

FILEDSN Name of a .dsn file. The driver builds the

connection string for the data source

with the information stored in this file.

DRIVER Description of the driver as returned by

the SQLDrivers API. For example, Rdb

or SQL Server.

SAVEFILE The file name of a .dsn file. The attribute

values of keywords used for the

present, successful connection are

saved in this file.

FETCHBUFFERSIZE Number of kbytes to fetch from server, or

SYSTEM_DEFAULT.

SQLFRACTIONVALUE Precision, 6 or 9.

SQL_ATTR_CONNECTION_TIMEOUT Timeout information: NO_TIMEOUT or

value in seconds.

SQL_LOGIN_TIMEOUT Timeout information: NO_TIMEOUT or

value in seconds.

SQL_QUERY_TIMEOUT Timeout information: NO_TIMEOUT or

value in seconds.