Neoview ODBC Drivers Manual (R2.5)

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.
3. Select the Custom Trace DLL (the trace file name) you want to use. Use the Select DLL button
to locate the correct file.
If you select the ODBC standard trace DLL (odbctrac.dll in the Windows\system32 directory),
only the driver manager is traced; additional trace options you select are ignored.
If you select the ODBC trace DLL (hp_odbctrace0200.dll in the Windows\system32 directory),
all trace options you select for the client data source are operational.
58 Configuring Client Data Sources