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
HP NonStop ODBC/MX Driver for Windows—691126-002
1-1
1 ODBC/MX Client Overview
Applications developed for the Microsoft® Open Database Connectivity (ODBC)
application programming interface (API) can use SQL/MX to access a NonStop SQL
database on an HP NonStop server, through HP NonStop SQL/MX connectivity
services (MXCS).
Client Components
Client components are installed on any workstation running Microsoft Windows 98,
Windows NT 4, Windows 2000, Windows 2000 Server, Windows 2003 Server,
Windows XP, Windows Vista, or Windows 7.
ODBC client application: A user-written application or third-party product that uses
the ODBC API to access data.
Microsoft ODBC 3.51 (or later) driver manager: Manages access to ODBC drivers
for applications. The driver manager loads and unloads drivers and passes calls
for ODBC functions to the correct driver.
ODBC/MX driver: Implements ODBC function calls (a subset of the ODBC 3.5.1
API), which allow an ODBC client application to access a NonStop SQL database
through the MXCS service.
The Microsoft ODBC Data Source Administrator.
Data Sources
To configure ODBC client access to SQL/MX (which accesses NonStop SQL
databases), MXCS requires data source definitions on both the NonStop server and
the client workstation.
Client Components
1-1
Data Sources 1-1
Connections 1-2
Object Naming and Mapping 1-6
Release Considerations and Restrictions 1-8
Traces 1-10
Unsupported ODBC API Functions and Data Types 1-11
ODBC/MX Driver Features 1-11
Limitations of ODBC/MX Driver 1-12