Oracle 1013 error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have read many users with this problem but no one seems
to know the solution. i have linked tables to an external
oracle database. when runnning a query, after about 60
seconds i get an oracle 1013 error. anyone ever have this
problem and how to solve?
 
Hi,
Take your subject heading, search on Google and you'll get tons of hits.
Here's one:
http://www.bris.ac.uk/is/services/software/packages/odbc/
Query times out with 1013 user requested cancel of current operation
a.. set connectiontimeout and query_timeout to 0 using regedit
b.. check configuration parameters of data source with ODBC Administrator- disable enable query timeout, enable LOBs, enable
Result sets, enable Disable MTS support
c.. look at Tools/options/Advanced- you may want to decrease the ODBC refresh interval
d.. Look at the properties of the query and set ODBC timeout to 0. By default it is set to 60 seconds
HTH
Dan Artuso, MVP
 
Back
Top