Re: ODBC Problem with ORA-01013 Error

From: Kurt Johnson <kujotx_at_hotmail.com>
Date: Wed, 26 Jan 2000 12:21:50 -0600
Message-ID: <CVGj4.55348$Rj5.38404@dfw-read.news.verio.net>

Roland:

This is only a guess from the infomration provided. But you might set the TIMEOUT property of the query to 0 -- meaning DON'T timeout.

I suspect that Access is quitting before the query can supply the records because your table is so HUGE.

Just a guess and I hope I helped,

Kurt Johnson

"Roland Bodenmann" <altrucin_at_gmx.ch> wrote in message news:86n57m$163$1_at_pacifica.access.ch...
> Hi all
>
> We have a strange problem concerning ORACLE 8.0.5.1 and
> Access 97 with ODBC
>
> when a user executes a query in Access he gets an ODBC error
> with the ORA-01013 message telling the user aborted the request.
>
> This happens on a table with 7000000 rows and he wants to group
> on one of the columns which should result in about 30 ROWS.
>
> There is no index on that row but on some other columns.
>
> Is this familiar to anyone ?
>
> Kind Regards
>
> Roland Bodenmann
>
>
Received on Wed Jan 26 2000 - 12:21:50 CST