ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-42
Examples of Installation
2. Select the option to add a datasource and select the SQL driver. Click OK. You will
see the SQL ODBC Setup screen. Enter the following:
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 may
now use the NonStop Connect Tool on the PC to test your connection.
1. Run the NonStop Connectivity Tool; you can select its icon from the 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 will display the Session Logon screen.
Data Source Name nsoadmin (any name is allowed)
Description Optional
Protocol WinSockets
Login Timeout Use the default, 0 (zero)
Host Name The IP address corresponding to the installed NonStop
system.
Port Enter the port number you entered into
$SYSTEM.ZTCPIP.SERVICES in Step 2 on page 2-40
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-40