ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-33
ODBC Installation
The experiments you can do are as follows:
When you have finished running experiments, use FILE | DISCONNECT and exit
from the Connectivity Tool.
Microsoft ODBC Test allows you to set up and issue single ODBC calls. For
example, you can connect to a datasource, execute SQL statements, and read the
results (and see them on the screen). You could use ODBC Test as another way to
verify connectivity to the NonStop system. In whatever way you verify connectivity,
you should also be sure to run some SQL statements either from the Connectivity
Tool or from ODBC Test.
3. To run Microsoft ODBC Test, select its icon from the SQL Program Group and
follow directions for connecting and for executing SQL statements.
4. When the preceding steps have been completed successfully, you can install and
run the client applications. You can run the Connectivity Tool or Microsoft ODBC
Test at any time to verify connectivity to NonStop, test SQL execution, and
measure response times.
CONNECT The tool repeatedly connects to and disconnects from the
datasource you have specified (using the same username and
password each time). This experiment tells you how much time
is needed just to connect to a NonStop ODBC server. If you
have configured SCS server classes so that NonStop ODBC
servers are prestarted, the connect time experiment tells you
what the network latency is.
ECHO Using one connection, the tool repeatedly sends an “echo”
command to the NonStop ODBC Server. The NonStop ODBC
server immediately replies to the echo (it does not issue any
SQL/MP activity nor does it return any data). This experiment
tells you the minimum time needed for a round trip message
from the client to the NonStop ODBC server and back.
Therefore, it helps you understand how much of your wait time
is for network latency.
QUERY Using one connection, the tool repeatedly executes the SQL
statement you enter in the area at the bottom. If you execute a
SQL SELECT statement, the tool does not fetch any of the
result rows but merely issues an ODBC Execute Direct call and
then closes the cursor by executing an ODBC Free Statement
call. The difference between the query time and the echo time
is the amount of time required for the NonStop ODBC server to
translate and execute the SQL statement and to return the
results.