ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server

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

2-40

Examples of Installation

On the NonStop server side using TCP/IP communication, follow these steps:

1. Log on as a super-group user (group ID 255).

2. If you do not have a network service name and port number entry in the

$SYSTEM.ZTCPIP.SERVICES file, you need to add a line. For example:

ODBCTEST 2700/TCP

3. At a TACL prompt, add a =_NSODBC_SYSTEM_CATALOG define to point to

where you want the ODBC system catalog to be created:

DELETE DEFINE =_NSODBC_SYSTEM_CATALOG

ADD DEFINE =_NSODBC_SYSTEM_CATALOG, CLASS CATALOG, SUBVOL

$vol.subvol

4. Run NOSCOM from a TACL prompt:

NOSCOM

5. Create the ODBC system catalog:

NOSCOM> SYSCAT INSTALL

6. Create a user catalog:

NOSCOM> USERCAT INSTALL Guardian-subvolume

7. Add an SCS configuration:

NOSCOM> ADD SCS SCS-name SCS_object $vol.subvol.SCSobj &

>nos_object $vol.subvol.NOS &

>nosutil_object $vol.subvol.NOSUTIL swapvol $swapvol-volume

Example:

NOSCOM> ADD SCS $HRSCS scs_object $SQLCON.ZNOSD31.SCSOBJ &

>nos_object $SQLCON.ZNOSD31.NOS &

>nosutil_object $SQLCON.ZNOSD31.NOSUTIL SWAPVOL $ODBC

8. Add the network service information. For the net_name, use the same name that

you used in Step 2 on page 2-40:

NOSCOM> ADD net_service SCS-name net_protocol tcp/ip &

>net_name network-name iop_name $ztc0 (for conventional/classic

TCP/IP)

NOSCOM> ADD net_service SCS-name net_protocol tcp/ip &

>net_name network-name iop_name <parallel tcp/ip process

name>