microsoft access odbc calls to oracle failing

The stuff below is related unsuccessful attemps to reslove odbc calls failing after 60 seconds ([Oracle][ODBC][ORA] ORA-01013 User requested cancel of current operation) with oracle support. This is with the current (and old) oracle odbc drivers using access 97 and an oracle 8.0.4 rdbms on digital unix 4.0b. I've tried everything to get these oracle odbc drivers to work. I should note we have been using the intersolv drivers which work and seem to ignore certain settings and queries can run as long as needed, unfortunately they are not free

I have also seen searched some previous problems on deja-news but unfortunately didn't find any resolutions that worked

Suggested sqlnet.ora file entry "sqlnet_expire_time" parameter may have something to do with it. But this file is not on the server, only a sample. And of two client machines only one had it and it didn't have the entry.

sent to desktop group

requested to try query in odbc testing utility - this worked requested to try installing access service packs 1 and 2 - did not work tried installing microsoft data access pack - this did not work

Tried installing latest ODBC driver 8.0.5.2.0. did not work

according to oracle
on further analysis, this problem is related to MS Access97 as detailed in Bug#700726.

The workaround for this Access97 bug formulated by our developers is as follows:

Firstly, all three of the following parameters must be set to the same value for any of them
to be effective:
1. Change the parameter "QueryTimeout" at;

        HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\ODBC  note: also tried setting connection timout to 0 2. Change the "CPTimeout " in

        HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Oracle ODBC Driver

The default value of "CPTimeout" is 60 if you do not have such a entry added into your registry.

3. In Ms Access change the "Refresh Interval". Start MS Access97 and from the menu:

        Tools -->Options ---> Advanced

Again please note that all of these parameters must have the same value or else MS Access97
ignores them all and just uses the default of 60 seconds.

ction timout to 0
2. Change the "CPTimeout " in

        HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Oracle ODBC Driver

The default value of "CPTimeout" is 60 if you do not have such a entry added into your registry.

3. In Ms Access change the "Refresh Interval". Start MS Access97 and from the menu:

        Tools -->Options ---> Advanced

Again please note that all of these parameters must have the same value or else MS Access97
ignores them all and just uses the default of 60 seconds.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 03 1998 - 00:00:00 CET