SQL/MX Connectivity Service Manual (SQL/MX 2.x)
Overview of MXCS
HP NonStop SQL/MX Connectivity Service Manual—524944-008
1-5
Connection Mapping
Connection Mapping
MXCS maps the client data source name in an incoming connection request to the
server data source name (names are case sensitive). If the name matches but the
server data source is not started, the connection request is rejected. If the server data
source name does not exist, the association server routes the connection to the default
data source. If the default data source is not started, the connection request is
rejected.
After a data source name is assigned, the association server uses any MXCS server
that was previously used by the same user ID. If no such server is found, the
association server assigns the first available server to the connection and reinitializes
the user context to the one defined in the configuration for the data source name on
the MXCS SQL server.
Figure 1-2. Connection Data Flow
Tdm_Default_DataSourceOther Data Source: DS1
1. Request connection to DS1
2. Connection to DS1 granted
3. Client connects to server
4. Server accepts connection
Client
Application
MXCS
Association
Server
MXCS
SQL Server
MXCS
SQL Server
Client API
Client Driver Manager
Client Driver
VST002.vsd