How to understand trace file to qet access query linked to Oracle7 via ODBC

Hi all, I need help with a query that doesn't work in Access97 to retrieving data on a view from Oracle7.2 via ODBBC Oracle 73 driver version 2.05. The query works fine when I connect to the instance where the view is originally defined, but the exact same query does not work when connecting to a 2nd instance which uses an Oracle DBlink to reference the view in the 1st instance.

When I turn oracle trace on in the Oracle73 ODBC driver, I get the error message SQL*FETCH RETURN CODE -1. Fetch out of sequence. What does this mean?!

When I use the Merant intersolv odbc driver, the query works fine! Why is this?

(In production I am not allowed to use the Merant driver, because the company standard is the Oracle73 driver.)

Final note: the query works fine via the Oracle DBlink if I hardcode the input value in the selection criteria box in ACCESS: where dept_no = 1. It fails when I use the access parameter syntax by typing [input] in the access97 selection criteria box to prompt the user for a value when running the query. The [input] syntax works for all other queries with do not reference tables over an Oracle dblink.

Does anyone have any experience with this or advice on this kind of problem?

Thanks in advance.

Geraldine.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 16 1999 - 13:10:03 CDT