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

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.