ODBC Server Reference Manual

Architecture Overview
HP NonStop ODBC Server Reference Manual—429151-002
2-11
Connections
Connections
A client application uses the NonStop ODBC Server by connecting to a particular
NonStop ODBC server, issuing SQL statements, and disconnecting, as shown in
Figure 2-12.
A connection is the model for client/server interactions with SQL database systems for
both DBLIB and ODBC. The client application can do more, such as having several
concurrent connections or automatically handling connect/disconnect for the end user,
but the basic mechanism is the same.
The connecting process, in which the application identifies itself and provides a
password and database name, is described in the next subsection.
In addition to an application program invoking connections, there are other client-side
aspects of using the NonStop ODBC Server. With DBLIB and ODBC, the parameters
of a connection (read/write or read-only, which database to use, and so on) can be
configured before the application connects or before the application program is run. In
addition, other parameters (maximum data returned, database to use, and so on) can
be altered by the application during the connection. See Figure 2-13.
Figure 2-12. A Client Connection With the NonStop ODBC Server
SQL Activity
One connection with a NonStop ODBC Server process
Timeline
Connect to
NonStopODBC,
provide
password,
choose
database
Disconnect
from NonStop
ODBC
Commit
transaction
Begin
transaction
Commit
transaction
Begin a
transaction,
issue SQL
statements
SQL Activity
VST016.vsd