Neoview ODBC Drivers Manual (R2.2 SP1)

Reconfiguring ODBC Client Data Sources
1. Start the Microsoft ODBC Administrator:
Start> Programs> HP ODBC 2.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 2.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.
Tracing Client Data Sources
Configure tracing on a client data source
1. Start the Microsoft ODBC Administrator:
Start> Programs> HP ODBC 2.0> MS ODBC Administrator
2. Select a data source name then click Configure.
3. Select the Tracing tab.
4. Select one or both trace options.
5. Select a log file name.
6. Click Apply then click OK.
For more information about a screen, click Help.
Start tracing on a client data source
1. Bring up the Microsoft ODBC Administrator:
Start> Programs> HP ODBC 2.0> MS ODBC Administrator
2. Select the Tracing tab.
46 Configuring Client Data Sources