ODBC Server Reference Manual

Introduction
HP NonStop ODBC Server Reference Manual—429151-002
1-3
DB-LIBRARY Interface
Figure 1-2 shows the relationships among an application, the ODBC interface, ODBC
drivers, and the servers with which they relate.
A number of different ODBC drivers (code that enables connection to a server), each
created for a different server, are supplied by different manufacturers. When the
application requests a connection to a specific server (by name), the ODBC Driver
Manager (supplied by Microsoft as part of Windows or NT) loads the appropriate driver
as a Dynamic Link Library (DLL); the driver then connects to the server.
Most drivers support the ODBC CORE SQL “dialect” of the SQL language; they all
support their own host dialects of SQL. The HP NonStop ODBC/MP Driver supports
the CORE SQL dialect.
DB-LIBRARY Interface
Figure 1-3 shows the relationships among an application using DB-LIBRARY interface,
the server connection code, and the server.
The DB-LIBRARY interface uses the Transact-SQL dialect of the SQL language
exclusively. An application of this type can communicate with either the NonStop
ODBC Server or the SQL Server.
Figure 1-2. ODBC Interface
Figure 1-3. DB-LIBRARY Interface
NonStop
ODBC
Server
Other Server
Application
HP Driver
O
D
B
C
Other
Driver
VST002.vsd
NonStop
ODBC
Server
SQL Server
Application
DBLIB
D
D
B
L
I
B
VST003.vsd