ODBC Server Installation and Management Manual
Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-7
Preparation
Preparation
To prepare for the installation, check requirements on all systems involved and plan
your installation strategy. If you currently have an old NonStop ODBC Server installed,
you might want to do backups first. See When to Back Up on page 2-13.
Understand the Application
Before you begin installation, read the NonStop ODBC Server documentation and
understand the applications to be supported. Questions to consider are:
•
What type of application is it? What type of SQL load will there be (little queries,
big queries, updating)? How many clients will be connected? How much SQL
activity is expected from each client? What are the security needs (a lot, not much,
many or few usernames)?
•
What are the network needs? How many clients are expected? How many SCS
processes should be configured?
•
What does SQL/MP need? Will you use existing databases or build new ones?
How many logical user names will there be on the NonStop system? How many
alias names?
•
What are the performance needs? Is a fast connection needed? Is caching of SQL
compilations needed?
Checking the NonStop System
Verify that the following conditions are met on the NonStop system. You can use
VPROC to determine the release version of most software.
•
A NonStop system running the D32 or later version of the NonStop Kernel
•
SQL/MP D32 or later version
•
Transaction Management Facility (TMF) software
•
Pathway/TS D40 or later version (if the stored procedure execution feature is used)
•
For TCP/IP connections, HP TCP/IP D40 or later version
Checking the PC Clients
Clients on PCs can be either ODBC clients or DBLIB clients.
ODBC clients run on Microsoft Windows. DBLIB clients can run on DOS, Windows,
OS/2, or UNIX platforms. For transport, any of these clients can use TCP/IP, as
supplied by Microsoft Corporation, FTP, UB Networks (for PC/TCP Applications +
BNS/NDIS), TCPPRO, or Novell LAN WorkPlace. The Winsock (version 1.x) interface
is also supported.