ODBC/MX Driver for Windows Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)
Table Of Contents
- HP NonStop ODBC/MX Driver for Windows
- Legal Notices
- Contents
- What’s New in This Manual
- About This Manual
- 1 ODBC/MX Client Overview
- 2 Installation of the ODBC/MX Client
- 3 Configuring Client Data Sources on Windows
- Accessing the Microsoft ODBC Data Source Administrator from a Client Workstation
- Adding New Client Data Sources
- Reconfiguring Client Data Sources
- Configuring Client Data Sources using Connection String
- Configuring Client Data Sources for Update Operations
- Configuring Driver for IPV6
- Removing Client Data Sources
- Tracing Client Data Sources
- 4 Module File Caching (MFC)
- 5 ODBC/MX Conformance
- ODBC API Functions
- SQL Conformance Level
- SQL Scalar Functions
- ODBC Data Types
- Unsigned Data Types
- Partial Date/Time Values
- SQL/MP Data Types and ODBC/MX Equivalents
- Microsoft Escape Clauses
- Stored Procedures
- Transactions and Cursor Behavior with Multiple Statements
- Timestamp Values with Fraction
- SQL Interval Insertion Property
- SQL Datetime Retrieval Property
- 6 ODBC/MX Messages
- Glossary
- Index
ODBC/MX Client Overview
HP NonStop ODBC/MX Driver for Windows—691126-002
1-3
Connection Mapping
3. The ODBC client application sends a connection request to the MXCS SQL server
that was assigned by the association server. If the user information is not valid, the
connection is rejected.
4. When the ODBC client application disconnects, the MXCS SQL server notifies the
association server that it is available for connections from other ODBC clients and
returns to the server data source pool.
An ODBC client application can connect to the default data source without needing to
create an MXCS SQL server data source.
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
Figure 1-1. Connection Data Flow
v
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
ODBC Client
Application
MXCS
Association
Server
MXCS
SQL Server
MXCS
SQL Server
ODBC API
ODBC Driver Manager
ODBC/MX Driver
VST002.vsd