ODBC Server Reference Manual

Introduction

HP NonStop ODBC Server Reference Manual—429151-002

1-4

How the NonStop ODBC Server Works

A workstation-based application program written to run with ODBC contains calls to the

ODBC API that the NonStop ODBC/MP Driver packages for transmission to the

NonStop ODBC Server. An application written to run with SQL Server contains calls to

the DBLIB API to perform similar functions.

Figure 1-4 illustrates how the NonStop ODBC Server accepts SQL statements, submits

them to NonStop SQL/MP, and returns the output to the client application.

As illustrated in this figure, an SQL statement (CORE SQL for ODBC, Transact-SQL

for DBLIB) is submitted to NonStop SQL/MP as follows:

1. An application issues an ODBC or DB-LIBRARY call that sends an SQL statement

to the NonStop ODBC Server.

2. The NonStop ODBC Server converts the client SQL statement to a NonStop

SQL/MP statement and sends the statement on to NonStop SQL/MP.

3. NonStop SQL/MP processes the statement and returns NonStop SQL/MP data (or

a diagnostic message) to the NonStop ODBC Server.

4. The NonStop ODBC Server converts the NonStop SQL/MP output to ODBC or

SQL Server format and sends the data to the application program.

Finally, the application retrieves the data using ODBC or DB-LIBRARY calls.

Figure 1-4. Relationships Among Applications, the NonStop ODBC Server, and

NonStop SQL/MP

Step 4:

Results in

ODBC or DBLIB

Format

Workstation

Step 3:

NonStop SQL/MP

Results

Step 2:

NonStop SL/MP

Statements

HP Server

Step 1:

CORE SQL or TSQL

Statements

NonStop

ODBC

Server

Application

With ODBC or

DBLIB Calls

NonStop

SQL/MP

VST004.vsd