|
Subject:
|
[Oracle][ODBC][Ora][ORA-01013
|
|
Posted By:
|
Corey
|
Post Date:
|
12/15/2006 9:20:15 AM
|
Hello again
I’m trying to understand why I’m getting the message below and how I can fix it.
This happens when ever I try to run a larger qry, and it pops up within a minute.
Any help would be very much appreciated
OBDC –call failed
[Oracle][ODBC][Ora][ORA-01013: user requested cancel of current operation (#1013)
Thank you
Corey
|
|
Reply By:
|
leehambly
|
Reply Date:
|
12/15/2006 9:29:38 AM
|
Corey,
Not sure how helpful this is, it is a timeout, basically.
You mention only happens with larger qrys...
so, can you do a pass-through query to the Oracle db, so the processing is carried out on the server? Same as a normal qry, but when written, right click on the table window of the query design and select SQL Specific --> Pass-through... I'm not a Oracle person though so I would step carefully if not used before though.
|
