MX Release 3.2 (H06.25+, J06.14+)

1 ODBC/MX Client Overview

This chapter includes these sections:

• Client Components

• Data Sources

• OSS ODBC/MX Client Driver Architecture

• Connections

• Object Naming and Mapping

• Release Considerations and Restrictions

• Traces

• Supported APIs

• Unsupported ODBC API Functions and Data Types

• OSS ODBC/MX Client Driver Features

• Limitations of OSS ODBC/MX Client Driver

Applications developed for the OSS Open Database Connectivity (ODBC) application programming

interface (API) access a NonStop SQL database on an HP NonStop server, through HP NonStop

SQL/MX connectivity services (MXCS).

Client Components

Client components are installed in the OSS environment for J06.12 and all subsequent J-series

RVUs and H06.23 and all subsequent H-series RUVs.

• ODBC client application: A user-written application or third-party product that uses the ODBC

API to access data.

• OSS ODBC/MX Client Driver: Implements ODBC functions (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.

Data Sources

To configure ODBC client access to SQL/MX (which accesses NonStop SQL databases), MXCS

requires a data source to be defined and started on NonStop server.

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

or MXCI in MXCS mode (MACL) or with SQL/MX Database Manager(MXDM, which is available

from SQL/MX 3.2 release onwards), but you cannot delete it. The TDM_Default_DataSource has

these functions:

• ODBC clients can connect to TDM_Default_DataSource and access a NonStop SQL database

with no special configuration required.

• If an ODBC client tries to connect to a data source in the NonStop system, and the client data

source name and the NonStop system data source name do not match (including the case),

the Association Server connects the ODBC client to TDM_Default_DataSource.

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

the connection.

Client Components 13