ODBC Server Reference Manual

HP NonStop ODBC Server Reference Manual—429151-002
2-1
2 Architecture Overview
This section gives a high-level architectural overview of the HP NonStop ODBC Server,
showing how the components of the NonStop ODBC Server interact to provide
connectivity to HP NonStop SQL/MP databases for client applications that issue SQL
statements from either Microsoft’s ODBC interface or SQL Server’s DBLIB interface.
This section covers the following topics:
•
Background information, including client/server operations and SQL gateways
•
Client-side view of the NonStop ODBC Server, including types of clients,
databases and datasources, and client connections
•
Server-side view of the NonStop ODBC Server, including the following:
°
Major components of the NonStop ODBC Server
°
Message flows
°
Objects and relationships
°
Name mapping
°
NonStop ODBC Server catalogs
°
NonStop ODBC server (the server process within the NonStop ODBC Server)
°
SQL communication subsystem (SCS)
°
NonStop ODBC Server utilities (NOSCOM and NOSUTIL)
°
NonStop ODBC Server execution
Figure 2-1 shows the most simplified view of the NonStop ODBC Server architecture.
The NonStop ODBC Server consists of processes on the HP server that translate
between the application SQL environment and the NonStop SQL/MP environment.
Some of these processes are utilities and others are the run-time translators. There is
also a facility to support the execution of Stored Procedures by issuing a
ServerClass_Send to a Pathway server class program. The NonStop ODBC Server
also includes a HP driver for ODBC clients that communicates with the server.