MX Release 3.2.1 (H06.26+, J06.15+)

1 ODBC/MX Client Overview

This chapter includes these sections:

• “Client Components” (page 13)

• “Data Source Configuration” (page 14)

• “OSS ODBC/MX Client Driver Architecture” (page 14)

• “Connections” (page 16)

• “Object Naming and Mapping” (page 18)

• “Release Considerations and Restrictions” (page 18)

• “Traces” (page 20)

• “Supported APIs” (page 20)

• “Unsupported ODBC API Functions and Data Types” (page 21)

• “OSS ODBC/MX Client Driver Features” (page 23)

• 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