ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-43
Configuration
2. Fill in the information on the screen:
3. Click OK.
Configuration
Configuring the NonStop ODBC Server involves managing NonStop ODBC Server
catalogs, usernames, alias names, their associated attributes, and stored procedures.
It also involves server classes and process attributes. This subsection describes the
basic configuration actions you can take and how you perform them. See Section 4,
Managing the NonStop ODBC Server, in this manual and “Managing Customized
Catalogs,” in the NonStop ODBC Server Reference Manual for complete descriptions
of the configuration commands.
Many of the configuration actions involve running the NOSCOM program supplied with
the NonStop ODBC Server. You can execute almost all utility statements in one of four
ways:
•
Using the HP Configuration Manager Tool from a NonStop ODBC installed PC
client.
•
Using the NOSCOM interface interactively:
RUN NOSCOM
NOSCOM> utility-statement parameters ...
•
Using the NOSCOM interface from a TACL prompt, using an input file:
RUN NOSCOM / IN file-of-utility-statements-and-parameters /
•
Using pass-through mode from a client application:
SELECT "tdm: util utility-statement parameters ..."
If you are using a client application that supports scripts of SQL statements, you can
essentially build NOSCOM scripts as batches of pass-through SQL statements.
NOSCOM uses SQL/MP to access the NonStop ODBC Server catalogs, so you must
have the required Guardian authority for the accesses.
The NonStop ODBC Server catalogs are expected to satisfy certain integrity
constraints. The NonStop ODBC Server does not strictly enforce this integrity,
however, because it cannot prevent SQL/MP access by others. The NonStop ODBC
Server’s own actions maintain catalog integrity, and NOSUTIL has options to check
(VALIDATE) and restore (REFRESH) that integrity.
Data Source nsoadmin
User ID nsoadmin or dbo
Password The SUPER.* password you entered in Step 2 on page 2-40