Re: Help: ODBC between Oracle and Access

From: <jocave_at_my-deja.com>
Date: Sat, 02 Sep 2000 00:45:42 GMT
Message-ID: <8opiji$vtg$1@nnrp1.deja.com>

In article <newscache$83a60g$1g3$1_at_njord.rim.net>, "Mike Heisz" <mheisz_at_rim.net> wrote:
> I am trying to set up ODBC on my computer. I believe that I have
everything
> set up corectly to access the oracle database. When I try to import
data
> from Oracle to Access I am able to select the particular view that I
want to
> import so I believe that it has to be finding the database OK. The
problem
> arises while the data is being transfered. I get the following error:
> [Oracle][ODBC][Ora]ORA-01013: user r(#1013)
>
> The Oracle documentation say that this error is that result of a user
> requested cancellation but I am not cancelling anything. The only
thing I
> can think of is that there is a timeout associated with the ODBC
driver.
> The query behind the view is slow and takes a couple of mins to
execute.
> Does anyone know if there is a timeout or what the problem may be?

In the ODBC Driver Setup, try unchecking the 'Enable Query Timeout' checkbox. It's possible that Access is requesting a timeout on the query.

Justin Cave
Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of Oracle corporation.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 01 2000 - 19:45:42 CDT