ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server

HP NonStop ODBC Server Installation and Management Manual—429395-002

2-54

Configuring ODBC Clients

As described under ODBC Installation on page 2-28, you can use the ODBC

administrator tool to add datasources. For each datasource, you can set the database

name and data access options.

When a NonStop ODBC server first starts, it reads all user attributes, including default

database and user profile from various NonStop ODBC Server catalog tables and

establishes the session defaults. When an ODBC client connects to a NonStop ODBC

server, it passes the ODBC client options that override session defaults. When the

ODBC client is disconnected, the NonStop ODBC server resets to the session defaults.

The following are the ODBC client options that can overwrite the session defaults:

SQL_ACCESS_MODE

SQL_CURSOR_MODE

SQL_DIALECT

SQL_TXN_ISOLATION

See Performance Tuning on page 4-7 for a full description.

Configuring SCS and Server Classes

Following are some SCS configuration considerations that can help improve

performance of the NonStop ODBC Server.

Additional Server Classes for Fast Connection

Under Installation Steps on page 2-16, Step 8—Run NOSINST on page 2-18 showed

NOSINST being used to configure SCS with only a DEFAULT server class. NonStop

ODBC servers in the DEFAULT server class do not provide for the fastest connection

by a client, as NonStop processes might need to be started. To achieve fast

connections, you will want to configure named server classes for specific usernames.

To use named server classes, use ADD USER and ADD UMAP statements to define a

username and specify its server class name. For example:

NOSCOM> ADD USER theuser SQL.ODBC PROFILE theprof

NOSCOM> ADD UMAP $thscs theuser SER_NAME theserverclass

Statement Caching

You can often obtain greatly improved response time for SQL execution by invoking

statement caching, in which SQL compiles are cached: the statement is compiled

using the SQL/MP statement PREPARE, and the prepared statement is maintained by

the NonStop ODBC Server for reuse.

Note. When configuring the ODBC datasource, the datasource settings on the PC override the

profile settings set up on the NonStop system for that user. It is very important to configure the

PC settings for ODBC datasources carefully to ensure the best performance.