Re: Oracle ODBC timeout from MS Access

On Tue, 15 Sep 1998 14:45:01 +0200, "Haha" <no.Spam_at_for.Everyone> wrote:

>I have been using Microsoft Access 97 to link to Oracle 7.3. This works
>through the SQL*Net (v2.3) and Oracle ODBC drivers. No problem while
>accessing the data. BUT: if I'm doing nothing on the connection for some
>time (like 2 or 3 minutes) and I want to access some data in Oracle,
>something goes wrong.
>MS Access crashes!!! That's not what I want, especially when at a
 customer
>site!
>
>Does anyone have any experience with this?

There is an ODBC parameter called "Connection Timeout". Set it to zero, and the driver will never more disconnect automatically.

BTW, check your ODBC version. For A97 --> Ora733 you should use ODBC Vers. 2.5.3.1.5 (i.e. 2.5.3.1.0b from www.oracle.com and an additional patch from ftp://support.oracle.de/pub/www/odbc/32/25315 32.zip).

HTH
        Chris

-- 
  Christoph J ngling
  Systemanalyse - Beratung - Software
  http://www.edv3.de