Microsoft Access ODBC Error When Running Database Query

When running a query on a table in Access using a Data Source ODBC, users may periodically get an ODBC error: "ORA-01013 User Requested Cancel of Current Operation." when the user did not cancel the query.

To fix this problem, the ODBC Driver settings need to be adjusted.  Follow these steps:

  1. Click Start > Settings >Control Panel > Administrative Tools > Data Sources (ODBC).
  2. Click the "System DSN" tab in the ODBC Data Source Administrator Window.
  3. Select the name of the Banner/Oracle data source from the list.
  4. Click the Configure button.

5.  On the Application tab of the Oracle ODBC Driver Configuration window, un-check all checkboxes with the exception of Read-Only Connection (refer to Figure 1).

red box around application tab

6.  On the Oracle tab of the Oracle ODBC Driver Configuration window, un-check the checkbox for Enable Failover  (refer to Figure 2).

7. Click OK to Save changes.

8. Reboot the PC.

red box around Failover, Enable Failover box
Article number: 
101855
Last updated: 
March 17, 2017
Service: 
Oracle Hosting and Administration
Category: 
Advanced Technical Information