ODBC Server Reference Manual

Architecture Overview
HP NonStop ODBC Server Reference Manual—429151-002
2-13
Server-Side View
In this figure, the client issues a SQLConnect ODBC CLI call that connects the client to
the SALES datasource with username SMITH and password “argh.” For an ODBC
client, the message flowing to the NonStop ODBC Server contains the username,
password, and the database name (obtained from the ODBC.INI file for
datasource=SALES). A DBLIB client would connect with the username, password, and
database name.
In ODBC on Windows, several other variants are available to the clients: the user ID or
password can be configured in the ODBC.INI file, or the driver can open a window and
prompt the user for a username, password, or both. In both ODBC and DBLIB, the
database name can alternatively be configured on the server side (based on the
username in the user profile).
Server-Side View
The server-side view of the NonStop ODBC Server architecture describes aspects
visible to the server administrator. This view includes the support of the NonStop
ODBC Server objects on NonStop servers, process architecture, message flows, and
configuration and management interfaces.
Major Components
The major components of the NonStop ODBC Server are shown in Figure 2-15.
Unshaded forms are relevant components other than NonStop ODBC server entities;
rectangles represent data.
Figure 2-14. NonStop ODBC Server Client Connection Process
SQLConnect (SALES, Smith, argh)
PEOPL
E
JOB
S
Datasource
SALES
SALESPEOPLE
REGIONS
SQL Catalog
Client
Application
HP
NonStop
ODBC/MP
Driver
O
D
B
C
USERNAME = Smith
PASSWORD = argh
DATABASE = N_DATA_SALES
VST0018.vsd