ODBC Server Reference Manual

Architecture Overview
HP NonStop ODBC Server Reference Manual—429151-002
2-6
Types of Clients
Types of Clients
The NonStop ODBC Server supports two types of clients, as shown in Figure 2-6.
•
Client 1 is a DBLIB/TSQL client, using the Transact-SQL (TSQL) dialect and
making DBLIB function calls.
•
Client 2 is an ODBC/CORE client; it uses ODBC CORE SQL and makes ODBC
CLI function calls.
For ease of discussion, the following terms are also used in the descriptions of clients:
The NonStop ODBC Server architecture is able to service both client types in the same
way, which is possible because the needs of both client types are usually the same. In
the few cases where they differ, the NonStop ODBC Server provides a solution to
accommodate them. For example, TSQL clients recognize names up to 32 characters
long and CORE clients recognize longer names; to accommodate both, the NonStop
ODBC Server supports 60-character names.
Figure 2-6. Two Types of Clients Supported by the NonStop ODBC Server
CORE client Uses CORE SQL dialect (client 2)
TSQL client Uses Transact-SQL dialect (client 1)
DBLIB client Uses DBLIB API (client 1)
ODBC client Uses ODBC API (client 2)
Clients Servers
1
SQL Server
Application
DBLIB
PC, Workstation, ...
Uses TRANSACT-SQL
HP Server
Supports TRANSACT-SQL
NonStop
ODBC Server
ODBC
Application
HP
Driver
PC
Uses CORE SQL
2
HP Server
Supports CORE SQL
NonStop
ODBC Server
NonStop SQL/MP
NonStop SQL/MP
VST010.vsd