How to fix Error 770 on Windows 11

by

Windows 11 Troubleshooting: Error 770 — “The data provider cannot fetch backwards through a result set”

Why This Error Happens

Error 770 occurs when an application attempts to navigate backward through a database cursor or result set that was opened as forward-only. This typically happens due to misconfigured ODBC/OLE DB driver settings, an outdated or corrupted database driver, or an application bug that requests a cursor type the underlying data provider does not support. It is commonly seen in legacy applications using ADO, DAO, or ODBC connections on Windows 11 where driver defaults have changed or been reset during an OS update.

Step-by-Step Resolution Guide

  1. Check and Update the ODBC Driver
  • Press Win + R, type odbcad32.exe, and press Enter.
  • Go to the System DSN or User DSN tab, select the relevant data source, and click Configure.
  • Ensure the driver version matches the database server version. If outdated, download and install the latest driver from the database vendor (e.g., Microsoft SQL Server ODBC Driver, MySQL Connector).
  1. Modify the Cursor Type in the Connection String
  • Locate the application’s connection configuration (often in a .ini, .config, or registry key under HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\[DSN Name]).
  • Change the cursor type parameter from ForwardOnly to Static or Keyset. For example, in an ADO connection string, add or modify:

    CursorType=adOpenStatic
  1. Repair or Reinstall the Database Client Software
  • Open Settings > Apps > Installed Apps.
  • Locate the database client (e.g., SQL Server Native Client, Oracle Client) and select Modify > Repair.
  • If repair fails, uninstall completely and reinstall the latest compatible version for Windows 11.
  1. Clear and Rebuild ODBC Cache
  • Close all applications using the data source.
  • Delete cached connection files (if applicable) from %APPDATA%\Microsoft\ODBC or the application’s local cache folder.
  • Reopen the ODBC Data Source Administrator and re-test the connection using the Test Connection button.
  1. Update Windows and .NET Framework Components
  • Go to Settings > Windows Update and install all pending updates.
  • Ensure .NET Framework 3.5/4.8 (commonly required by legacy data applications) is enabled via Control Panel > Programs > Turn Windows features on or off.

Alternative or Verification Steps

  • Verify the fix: Reopen the application and perform the action that previously triggered Error 770 (e.g., scrolling backward through records or using a “Previous” button in a data grid). If no error appears and backward navigation works, the issue is resolved.
  • Alternative solution: If modifying the cursor type is not possible within the application, contact the software vendor for a patch, or use a middleware/reporting tool that supports static cursors to query the same database instead of the native application.