HP Integrity NonStop H-Series - Manual (Page 25)

3. Select the data source name that you want to configure and click Configure.
4. Each tab in the configuration view displays different fields in the data source configuration.
Make the required changes.
For more information about the Microsoft ODBC Data Source Administrator screens and
tabs, click Help.
NOTE:
•
While creating a new data source, ensure the following special characters are not part
of the data source name:
\, /, :, *, ?, “, <, >, |
•
When creating a new client data source, ensure that it matches that of a server data source
name and have the matching case. If a client data source name does not exist on the
server, the default server data source, TDM_Default_DataSource is used.
The following connection string is used to configure the client data source:
"DSN=< DataSource name>;catalog=; schema=;
Uid=;Pwd=;FETCHBUFFERSIZE=bytes>; SQLFRACTIONVALUE=;ATTR_CONNECTION_TIMEOUT=;
SQL_LOGIN_TIMEOUT=;SQL_QUERY_TIMEOUT=”;
For more information about the attributes, see MXODSN and ODBCDSN file formats .
nl
Table 2 explains the driver connection attributes specific to Windows driver:
Table 2 Connection attributes
Description Attribute
Name of the data source as returned by
SQLDataSources
API or the data sources dialog box
of SQLDriverConnect API.
DSN
Name of a .dsn file. The driver builds the connection
string for the data source with the information stored in
this file. FILEDSN
The file name of a .dsn file. The attribute values of
keywords used for the successful connection are saved
in this file. SAVEFILE
Description of the driver as returned by the SQLDrivers
API. For example, Rdb or SQL Server. DRIVER
Client error message language. This is equal to
SYSTEM_DEFAULT. The default is ENGLISH. ERRORMSGLANG
Used for setting Infer charset, default is
SYSTEM_DEFAULT, which is the client local character
set. CTRLINFERNCHAR
Translates the data from one character set to other. Set
the TRANSLATIONDLL in either of the following ways: TRANSLATIONDLL
• 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.
Options supported by the translation DLL. TRANSLATIONOPTION
NOTE: If DSN attribute is not provided in the connection string, the driver uses the SERVERDSN
as the default DSN.
Configuring a client data source 25