ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-6
Installation Versus Migration
•
If a previous version of the NonStop ODBC Server is already installed:
Migration involves installing the new NonStop ODBC Server software, moving to it,
and upgrading the catalogs. It is assumed that existing clients will run without
change on the newer software (they can be migrated later to use the newer
NonStop ODBC driver). Tools are provided to extract configuration specifications
from the SCS edit files and the NonStop ODBC system catalog metadata tables
(Z*).
•
If you want to upgrade clients to new versions of DBLIB or ODBC, note that in
most cases, the client software and the NonStop ODBC Server software on the
NonStop system do not need to be upgraded simultaneously. In some cases,
however, it may be necessary for the client and NonStop ODBC Server software
upgrades to be synchronized—this is noted in the softdoc when applicable. In
general, if both NonStop systems and client systems are to be upgraded, it is best
to upgrade both at the same time.
•
Unlimited statement caching is no longer supported in Release 2. In release 1,
SQL_MAX_STATEMENT_CACHE = -1 meant no limit on number of statements
cached. Release 2 does not support this unbounded cache, imposing a limit of
32767. If the -1 value is used, you must change the value it to 32767 before using
NOSU200 to migrate the catalog.
Under NonStop ODBC Release 2, more than one version of NonStop ODBC Server
software can run on a given node. Each catalog on a node can run a different version
of NonStop ODBC Server software. Note, however, that special rules exist for
managing SQL/MP data that is customized for ODBC access from more than one
NonStop ODBC catalog when multiple software versions are present.
Migration for Clients
The considerations for client migration are as follows:
•
If you are upgrading a DBLIB client, follow the Microsoft/Sybase instructions and
verify that the new client can connect to and use the NonStop ODBC Server on the
NonStop system.
•
If you are upgrading an ODBC client, do one of the following:
•
To migrate to a new version of the ODBC driver manager, follow Microsoft’s
instructions.
•
To migrate to a new version of the NonStop ODBC driver, follow the installation
instructions for Windows Setup, described in Installing the Client on the PC on
page 2-27.
•
To migrate to a new version of a communications stack, follow the vendor’s
instructions.
Note. Migration assumes that NonStop ODBC Release 1 is installed, as signified by the
system catalog version 100 or 110.