Neoview Database Administrator's Guide (R2.2)

9 Managing Client Data Sources and Connectivity
This chapter describes:
• “Reconfiguring ODBC Client Data Sources” (page 135)
• “Configuring ODBC Client Data Sources for Update Operations” (page 135)
• “Removing ODBC Client Data Sources” (page 135)
• “Performing Database Connectivity Tasks” (page 135)
• “NDCS Services” (page 136)
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
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 remove and then click Remove.
4. In the confirmation dialog box, click Yes to remove the data source or click No to cancel.
5. Repeat Steps 3 and 4 for each data source you want to remove.
For more information about a window, click Help.
Performing Database Connectivity Tasks
This subsection describes the Neoview Database Connectivity Services (NDCS) and how to
change NDCS configurations.
NDCS enables applications developed for the Microsoft Open Database Connectivity (ODBC)
and Java Database Connectivity (JDBC) application programming interfaces (APIs), the SequeLink
API, and other connectivity APIs to use Neoview SQL to access a Neoview SQL database on an
HP server.
Reconfiguring ODBC Client Data Sources 135