ODBC/MX Driver for Windows Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Configuring Client Data Sources on Windows
HP NonStop ODBC/MX Driver for Windows—691126-002
3-4
Configuring Client Data Sources for Update
Operations
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.
This prevents updating or deleting an incorrect row.
Configuring Driver for IPV6
To configure the Windows ODBC/MX driver to use IPV6:
1. Start the Microsoft ODBC Data Source Administrator by selecting the Start menu >
Programs > NonStop ODBCMX 3.2.
2. Create or modify a DSN in the NonStop(TM) ODBC/ MX Data Source configuration
screen.
3. Select the Network tab to enter the Ipv6 address in the MXCS IP Address field.
Figure 3-1 illustrates the ODBC/MX data source configuration settings.
TRANSLATIONDLL Translates the data from one character
set to other.
Set the TRANSLATIONDLL in either of
the following ways:

TRANSLATIONDLL=
<tdm_translation.dll>

Click Browse to select a DLL.
The DLL you specify is used to map the
character set for a particular language.
TRANSLATIONOPTION Options supported by the translation
DLL.
SERVERDSN Server Data Source.The default is
TDM_Default_DataSource.