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

Data sources
Data sources are logical groupings of connections to the SQL/MX database. There are two types
of data sources.
•
Client data source, commonly known as Data Source Name (DSN). The DSN is configured
on the client workstation.
•
Server data source, which you must define and start on the NonStop system.
The driver uses the client data source configuration to route the ODBC API requests to MXCS.
For more information about data sources, see the HP NonStop SQL/MX Connectivity Service
Manual for SQL/MX Release 3.x.
Client data source configuration
The client data sources are configured on the client workstation.
HP-UX, Linux32 and Linux 64
•
Configure the client data sources in the MXODSN file when the driver uses the SQL/MX
driver manager.
•
Configure the client data sources in the odbc.ini and odbcinst.ini files when the
driver uses the unixODBC driver manager.
OSS
You must configure the data source in the ODBCDSN file.
Windows
You must configure the client data sources with Microsoft ODBC Data Source Administrator.
The driver accesses the configuration details when it sends a connect request to MXCS. If the data
source is not configured on the server, MXCS connects the application to the default data source,
TDM_Default_DataSource
.
Server data source configuration
The server data sources are configured on a NonStop server. For more information about configuring
and managing server data sources, see the HP NonStop SQL/MX Connectivity Service Manual
for SQL/MX Release 3.x.
Default data source
TDM_Default_DataSource is the pre-configured default server data source. You can stop and
start TDM_Default_DataSource with any one of the following, but you cannot delete it:
•
NSM/web
•
SQL/MX Administrative Command Library (MACL, mode mxcs invoked from mxci)
•
SQL/MX Remote Conversational Interface (RMXCI)
•
SQL/MX Database Manager (available from SQL/MX Release 3.2 onwards)
MXCS establishes a connection with TDM_Default_DataSource when there is a mismatch in
the client and server data source names.
For more information about MACL, see the SQL/MX Connectivity Service Administrative Command
Reference .
Data sources 13