ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-36
Examples of Installation
C-Shell: “.cshrc” looks like:
setenv SYBASE /home/sybase
set path=(. /usr/ucb /bin /usr/bin /etc /usr/etc /home/sybase/bin)
7. Verify that you can connect to the NonStop ODBC Server and execute SQL
statements by running the Sybase interactive SQL tool called ISQL.
8. When the preceding steps have been completed successfully, you can install and
run the client applications. You can rerun ISQL with the SAMPNEW script at any
time to verify connectivity to the NonStop system and test SQL execution.
Examples of Installation
Here are some scenarios of how you might set up your system.
Create a Default Configuration With Load
In this example, ODBC is already installed, but you want to create a new ODBC
system catalog and user catalog using the Load option in NOSINST to create a default
configuration. If you do this you will be able to use the PC based HP ODBC
Configuration Manager to finish the configuration for your system.
On the NonStop side, using TCP/IP communication, follow these steps:
1. Log on as a super-group user (group ID 255).
2. 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
3. Change the volume to the location where the ODBC objects are located:
VOLUME ODBC-object-file-subvolume
4. Run NOSINST from a TACL prompt to create a new system catalog, as follows:
a. Respond with an I at the prompt:
?? ENTER KEY LETTER (shown in uppercase) OF OPTION : I
b. You now have the option to change the default subvolumes for various items. If
you need to change the NonStop ODBC System Catalog to the volume and
Note. Although additional entries can be placed in the PATH definition, these two entries
represent the minimum for running the NonStop ODBC Server client gateway. Examples
for these two shell definitions are in the files .PROFILE.EXAMPLE and.CSHRC.EXAMPLE
in the extracted Sun installation.