asked on 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-01
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
The Entries of SQLNET.ora file is given below:
# SQLNET.ORA Network Configuration File
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = world
SQLNET.AUTHENTICATION_SERV
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAME, HOSTNAME)
SQLNET.RECV_TIMEOUT= 300
SQLNET.SEND_TIMEOUT=300
Error-file.doc
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-01
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
The Entries of SQLNET.ora file is given below:
# SQLNET.ORA Network Configuration File
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = world
SQLNET.AUTHENTICATION_SERV
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAME, HOSTNAME)
SQLNET.RECV_TIMEOUT= 300
SQLNET.SEND_TIMEOUT=300
Error-file.doc
Oracle DatabaseMicrosoft Access
Last Comment
anandkswamy2008
ASKER
When running SQL query on MS- Access 2000 which has DBlink to Oracle 9i tables it probably takes about 7-8 minutes, but with Oracle 10G upgrade it is giving the ORA-01013:error.
How do you change the timeout value in your dsn settings?
Thanks
Anand
How do you change the timeout value in your dsn settings?
Thanks
Anand
It depends which ODBC driver you are using.. ORacle 8 ODBC driver implements timeout settings... you can also try setting
sqlnet.expire_time in sqlnet.ora to 10 ... ( i am not sure if that works)
sqlnet.expire_time in sqlnet.ora to 10 ... ( i am not sure if that works)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
http://www.cryer.co.uk/brian/oracle/ORA01013.htm
Try increasing the timeout value in your dsn settings....
How long the query runs by the way?