ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-31
ODBC Installation
7. Run the Microsoft ODBC Administrator (you can select this tool’s icon from the HP
NonStop SQL Program Group). Select the option to add a datasource and select
the SQL driver. You will see a screen prompting for the following input:
You can use the Microsoft ODBC Administrator tool to add new datasources, modify
existing datasources, or delete existing datasources at any time.
1. Run the HP Connectivity Tool; you can select its icon from the SQL Program
Group. Select the System Information Window to view versions of many
components and available system resources. Click in this window at any time to
cause the information to be updated.
You may also view a Connection Window. You can create additional Connection
Windows by choosing File | Connect from the Connection Menu.
Data Source
Name
The name the client will specify in the SQLConnect
statement. “NonStop ODBC” or the same name as the
Network Service name is suggested.
Description An optional comment: for example “NonStop ODBC
Server database on \node.$vol.subvol.”
Protocol The network protocol to use. There is only one choice,
NonStop WinSockets.
Login Timeout The number of seconds that the HP ODBC Driver waits
for a connection to be completed. 0 tells the driver to wait
indefinitely.
Host Name Input depends on the choice of protocol. For TCP/IP,
specify the IP address corresponding to the installed
NonStop system.
Port Chose the port number configured for SCS datasource.
In this example, it is 2314 for TCP/IP. For TCP/IP, other
site specific conventions can influence the choice.
Database The name of the database to be used for object
qualification and object abstractions.
Access Mode Acceptable values are: SQL_MODE_READ_WRITE,
SQL_MODE_READ_ONLY or SQL_MODE_NULL. See
Section 4, Managing the NonStop ODBC Server for more
details.
Cursor Default
Mode
Acceptable values are: FOR_UPDATE, READ_ONLY or
READ_ONLY_STREAMING.
Transaction
Isolation
Acceptable values are:
SQL_TXN_READ_UNCOMMITTED,
SQL_TXN_READ_COMMITTED,
SQL_TXN_REPEATABLE_READ or
SQL_TXN_SERIALIZABLE