ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-39
Examples of Installation
3. Click OK. You will return to the Data Sources window.
4. In the User Data Sources list, click on the new data source name (nsoadmin) that
you just created and click Close.
You are now set up on both the NonStop server side and the PC client side. You can
now use the Connectivity Tool on the PC to test your connection.
1. To run the Connectivity Tool select its icon from the NonStop SQL Program Group.
It displays the Connecting to Server screen.
2. Fill in the information on the screen:
3. Click OK.
After you are satisfied that you have a working ODBC system you may use the ODBC
Configuration Manager to further configure your ODBC system.
1. Run the ODBC Configuration Manager. It displays the Session Logon screen.
2. Fill in the information on the screen:
3. Click OK.
Create a New System Catalog With NOSCOM
In the next example, ODBC is already installed, but you want to create a new system
catalog and user catalog by using NOSCOM.
Host Name The IP address corresponding to the installed NonStop
system
Port The port number you entered into
$SYSTEM.ZTCPIP.SERVICES in Step 6 on page 2-38.
Database Master
Access Mode Use default SQL_MODE_READ_WRITE
Cursor Default
Mode
Use default FOR_UPDATE
Transaction
Isolation
Use default SQL_TXN_READ_UNCOMMITTED
Data Srcs nsoadmin
User ID nsoadmin or dbo
Password The SUPER.* password you entered in Step 1 on page 2-36
Data Source nsoadmin
User ID nsoadmin or dbo
Password The SUPER.* password you entered in Step 1 on page 2-36