Verifying or Editing an ODBC Definition on Windows

Use the following procedure to verify or edit an ODBC definition on Windows.

To verify or edit an ODBC definition on Windows

1. Start the registry editor (regedit).

   Caution: Editing the registry can adversely affect the operating system. Be sure you understand how to use regedit correctly.

2. Navigate to the following location: HKEY_LOCAL_MACHINE\Software\Wow6432Node\ODBC\ODBC.INI\ODBC_Name.

   ODBC_Name is the ODBC name for the Oracle Database.

3. In the data display pane, verify that the following entries are present:

   Name	Type	Data
   LobPreFetchSize	REG_SZ	8388608
   FetchBufferSize	REG_SZ	1048576

   If these entries are not present, then right-click in the data display pane, and choose New, and then String Value to add them.

4. Step off the ODBC_Name and return to it. Verify that the two new entries are present and correct.

5. Close the Registry Editor.