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

3 Configuring data sources
This chapter describes the various procedures to configure the SQL/MX data sources.
•
“Configuring a client data source”
•
“Configuring the drivers for IPv6”
•
“Configuring a secure ODBC connection using NonStop SSL”
•
“MXODSN and ODBCDSN file formats”
•
“Managing data sources”
•
“Managing transactions” (page 34)
•
“Tracing”
Configuring a client data source
Unix
The MXODSN file on HP-UX and Linux, or the ODBCDSN file on OSS, which is a text file, is a
repository of all client data sources.
You can place the MXODSN or ODBCDSN file in any one of the following locations; the search
order for these files are also mentioned:
1.
Directory specified in DSN_PATH environment variable
2. ODBC application directory
3. Default system location
•
On HP-UX, /etc/mxodbc
•
On Linux32 and Linux64, /etc/hpodbc
•
On OSS, /G/system/system, which is the OSS name for the Guardian location
To configure a client data source, edit the MXODSN or ODBCDSN file. Change this file so that
the attributes are set to the correct values for your system (for example, names of data sources
and attributes describing them).
The DSN in the MXODSN or ODBCDSN file must exactly match the server data source name
(data source names are case sensitive). If the data source names do not match, the application
gets a warning that connection is established with the default data source,
TDM_Default_DataSource
.
If you have not defined the CATALOG and SCHEMA attributes in the MXODSN or ODBCDSN files,
the driver uses the default values.
Windows
Perform the following steps to add a client data source:
1.
Select Start -> Control Panel -> Administrative Tools -> Data Sources
(ODBC)
.
2. Click Add to add a new data source. To configure a data source, get the list of data source
names by clicking either the System DSN or the User DSN tab.
3. Choose NonStop(TM) ODBCMX < Release > from the list, and then click Finish. < Release
>
is version or Unicode version.
4. Enter the details in the Create Data Source screens.
Perform the following steps to configure a client data source:
1.
Select Start -> Control Panel -> Administrative Tools -> Data Sources
(ODBC)
.
2. Click either the System DSN or the User DSN tab to get the list of data sources.
24 Configuring data sources