ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual429395-002
2-41
Examples of Installation
9. Add the serverclass definition:
NOSCOM> ADD serverclass server-class-name &
>max_servers max-#-of-servers & >
available_servers #-of-initially-started-servers &
>g_username Guardian-user-name-of-server-class-owner &
>profile profile-for-this-server-class
Example:
NOSCOM> ADD serverclass hrsc max_servers 3 available_servers
1 &
>g_username sql.henryr profile hrprof
10. Add the profile:
NOSCOM> ADD profile profile-for-this-server-class
Example:
NOSCOM> ADD profile hrprof
11. Add a user:
NOSCOM> ADD user logical-user-name Guardian-user-name
Example:
NOSCOM> ADD user henry sql.henryr
12. Add server class mapping:
NOSCOM> ADD smap SCS-name server-class-name
Example:
NOSCOM> ADD smap $hrscs hrsc
13. Add user mapping:
NOSCOM> ADD umap SCS-name &
alias name logical-user-name &
user_name server-class-name
Example:
NOSCOM> ADD umap $hrscs henry ser_name hrsc
14. Start the SCS process:
NOSCOM> START SCS $hrscs
On the PC client side using TCP/IP communication, follow these steps:
1. Run the Microsoft ODBC Administrator (you can select this tool’s icon from the
SQL Program Group).