Neoview Database Administrator's Guide (R2.5)

6 Managing Client Data Sources and Connectivity
This chapter describes:
• “For More Information About Neoview Connectivity” (page 31)
• “Reconfiguring ODBC Client Data Sources” (page 31)
• “Configuring ODBC Client Data Sources for Update Operations” (page 31)
• “Removing ODBC Client Data Sources” (page 31)
• “Neoview Database Connectivity Services (NDCS)” (page 32)
For More Information About Neoview Connectivity
See...For Information About...
Neoview ODBC Drivers ManualUnderstanding ODBC for Neoview
Neoview JDBC Type 4 Driver Programmer's Reference
Neoview JDBC Type 4 Driver API Reference
NOTE: The Neoview JDBC Type 4 Driver API Reference is
located here: http://www.docs.hp.com/en/busintellsol.html
Understanding JDBC for Neoview
• ODBC: README for the HP Neoview ODBC Driver for
Windows or README for the HP Neoview ODBC Driver
for UNIX
• JDBC: README for the HP Neoview JDBC Type 4 Driver
Installing ODBC and JDBC clients
HPDM Connectivity areaConnectivity status
Reconfiguring ODBC Client Data Sources
1. Start the Microsoft ODBC Administrator:
Start> Programs> HP ODBC 1.0> MS ODBC Administrator
2. To display the list of data source names, click either the System DSN tab or the User DSN
tab. (The tab on which a data source is listed depends on how the data source was originally
assigned.)
3. Select the data source name you want to reconfigure, and then click Configure. Each tab in
the configuration view displays different fields in the data source configuration.
4. Make the required changes.
For more information about a tab, click Help.
Configuring ODBC Client Data Sources for Update Operations
To perform “update . . . on the current of” SQL operations, use the ODBC Client Administrator
to set the fetch buffer size to zero to force the fetching of one row at a time instead of a buffered
fetch.
To prevent updating or deleting an incorrect row, an error is returned if:
• The SQL_ATTR_CONCURRENCY attribute is set to SQL_CONCUR_READ_ONLY.
• The WHERE CURRENT OF clause is used in an UPDATE or DELETE statement.
Removing ODBC Client Data Sources
1. Start the Microsoft ODBC Administrator:
Start> Programs> HP ODBC 1.0> MS ODBC Administrator
For More Information About Neoview Connectivity 31