ODBC - Call failed

G

Guest

I get an ORA-01013 when I run a request data in a query. I can run the query
for a small range of dates that selects about 52000 records, but when I run
the same query for a larger range, I get the Oracle error. I have no idea
how many records are being retrieved.
 
W

Wolfgang Enzinger

Hi Robin,
I get an ORA-01013 when I run a request data in a query. I can run the query
for a small range of dates that selects about 52000 records, but when I run
the same query for a larger range, I get the Oracle error. I have no idea
how many records are being retrieved.
Click to expand...

looks like your query runs into a timeout. Try increasing the value of
ODBCTimeout.

HTH,
Wolfgang
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC--Call failed. 4
Pass Through Query Make Table 3
error ORA-01013 2
Pass-Through Query Error 1
SQL Help Please 1
SQL Pass-Through Query to Oracle fails 3
Access Pass-through Query to SQL Server 6
Query against - ODBC Connect Oracle Table 1

Top