ODBC Server Reference Manual

Introduction

HP NonStop ODBC Server Reference Manual—429151-002

1-2

Application Interface

The NonStop ODBC Server allows NonStop SQL/MP access to applications written to

run using the ODBC API as well as those written to run with SQL Server. ODBC is the

application program interface for ODBC applications. The API for SQL Server

applications is called DB-LIBRARY (DBLIB). The following subsections describe the

differences and similarities in the two types of interfaces.

ODBC Interface

ODBC is Microsoft’s interface for accessing data in a heterogeneous environment of

database management systems. It provides a single interface for accessing data

stored in a variety of proprietary personal computer, minicomputer, and mainframe

databases. ODBC provides a universal data access interface to ease the need for

independent software vendors and corporate developers to use multiple APIs. By using

ODBC and ODBC drivers, an application can access data from multiple, diverse

databases.

Figure 1-1. Workstation-Based Tools Accessing NonStop SQL/MP Using the

NonStop ODBC Server

Clients Running

Workstation-Based

Tools

LAN

Special-Purpose Application

"Off-the-Shelf" Application

NonStop System Running

NonStop ODBC Server and

NonStop SQL/MP

Application-Development Tool

NonStop

ODBC Server

NonStop

SQL/MP

VST001.vsd