ORA-01013: user requested cancel of current operation (#1013) error with MS-Access 7 Oracle 10G
I'm running SQL query on MS- Access 2000 which has DBlink to Oracle 9i tables, this works fine.
We've recently we've upgraded from Oracle 9i to Oracle 10G Client only and when I try to run the same SQL query on MS- Access 2000 which has DBlink now to Oracle 10G, it gives the below error:
"[Oracle][ODBC][ORA]ORA-01013: user requested cancel of current operation (#1013)"
I have a System DSN that uses default values for everything. Therefore, I has the checkbox enabled that says, "Enable Query Timeout". It references TNSNAMES.ORA with the database (as well as several others) are configured
Try increasing the timeout value in your dsn settings....
How long the query runs by the way?