If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

I am trying to setup an Access 97 application that will view data in read-only mode from an Oracle 8.0.4.4.0 Database. If I use the SQL Plus 8.0 tool, the queries run fine and return the proper results. However, if I use the same SQL statement for a passthrough query in Access, I get Error: ORA-1013 User requested cancellation of current operation. This happens almost everytime after 55 seconds of running. No matter what the query statement is. I have set the query timeout to 3600 seconds to make sure that there was plenty of time allocated since I am pulling from a large table. Here is a sample of one of the failing queries:

SELECT SUM(CHESS_PROD.NET_DET.ORD_QTY) as "TotalOrder" FROM CHESS_PROD.NET_DET WHERE CHESS_PROD.NET_DET.ORD_QTY > 100000;

However, if I use a standard select query without the SUM, it comes back fine.

Does anybody have any suggestions or guidance, it would be GREATLY appreciated. I do not really have the approval to use stored procedures on the Oracle server. So I do need to at all costs find a way to use passthrough queries in Access to do some pretty complicated tasks.

Does ODBC tracing or SQLNET tracing provide any usefull information? For SQLNET tracing, put TRACE_LEVEL_CLIENT = 16 in your SQLNET.ORA. Don't forget to remove it after tracing, it can produce large tracefiles.