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










