MX 2.x)

Overview of MXCS

HP NonStop SQL/MX Connectivity Service Manual—524944-008

1-3

Client Data Sources

Default Data Source

MXCS provides a preconfigured, default server data source on the server called

TDM_Default_DataSource. You can stop and start the TDM_Default_DataSource

using NSM/web, but you cannot delete it. The TDM_Default_DataSource has these

functions:

•

Clients can connect to TDM_Default_DataSource and access a NonStop SQL

database with no special configuration required.

•

When a client tries to connect to a data source in the NonStop system, the

association server connects the client to TDM_Default_DataSource if one of the

following conditions exists:

the data source name and the NonStop system data source name do not

match (including the case).

the NonStop system data source does not exist.

Client Data Sources

Client data sources are used for ODBC/MX connections and reside on a client

workstation. Each client data source is a logical name that identifies the attribute

values used to connect to the MXCS service and defines some local behavior for the

connection. Use the Microsoft ODBC Data Source Administrator to add, configure, and

remove ODBC/MX client data sources.

Connections

Connecting a Client to a Data Source

Figure 1-2 shows the flow of data among the client and server components.

The MXCS association server starts and manages the MXCS SQL servers associated

with MXCS data sources in the NonStop system. When a client requests a connection

to a data source, the association server also associates the client with an available

MXCS SQL server. The following scenario describes how a client application connects

to an MXCS SQL server through the association server:

1. The client application sends, via an API call, a connection request to the MXCS

service. The client specifies an IP address or the NonStop server Domain Naming

Service (DNS) name and port number that is defined when you start the

association server. ODBC Clients connect to MXCS by connecting via a client data

source, which contains the connection-specific information. JDBC clients specify

Note. TDM_Default_DataSource must be in a started state for the client to be connected.

If an ODBC client tries to connect to any server data source that is stopped, MXCS rejects

the connection.