Communication link failure

Hello

We are using Access 2003 (SP2) to access a remote SQL 2000 database,
using ODBC with MDAC 2.8

This is an intermittent problem and it occurs on all the clients
(mostly winXP Pro)

The problem is that from time to time, the ODBC connection fails and we
get one of several errors:
ODBC--call failed
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).
(#10054) [Microsoft][ODBC SQL Server Driver][DBNETLIB].General network
error. Check your network documentation.
or
ODBC--call failed
[Microsoft][ODBC SQL Server Driver][Communications link failure (0#)

We know that sometimes there are network problems (we connect accross a
CDMA mobile network) - the cause of this is not in question......

Retrying the operation immediatly returns the same error but when we
close and re-open access and re-run the operation, and then it will
work straight away.

So, it seems that the driver enters a "failure state" - which is reset
when access is closed and re-opened.

I desperately need to find a way to "reset' the driver when this
happens so that we don't have to keep restarting access.

Anyway help would be much appreciated.

thanks !
Rob

.

Relevant Pages

  • Re: em device hangs on ifconfig alias ...
    ... before 6.1 was released that this reset was needed and couldn't be avoided to ensure performance of the device to work at its best, I can't remember his explanation, but this topic has come up before, of course anything is possible to fix. ... if that is the case, and both the switch and the interface are already locked at a speed (in my case, both are hard coded to "100baseTX full duplex", then what is there to re-negotiate? ... I run bge and fxp interfaces on this same network, against the same switch, all locked at the same speed, and only the em driver exhibits this problem ... ...
    (freebsd-stable)
  • Re: [GIT *] Allow request_firmware() to be satisfied from in-kernel, use it in more drivers.
    ... I still haven't seen an answer to the chip reset issues. ... driver isn't loading firmware, ... When a lot of these network drivers reset, ...
    (Linux-Kernel)
  • Re: SSIS package Informix to SS 2005
    ... I am using Avaya Openlink driver 4.2 and after much trial and error I have ... picking data from ODBC and pushing it to SS 2005 Database through SSIS ... Multi-tier ODBC Driver forInformix. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Problem with perl DBI ODBC driver (bug or misconfig ?) [String data right truncation]
    ... Therefore there is no problem at source or at ODBC level, ... but it is a bug in IBM iSeries driver. ... database in UTF-8. ... Denis had UTF-8 set and his data contained some ...
    (perl.dbi.users)
  • Microsoft ODBC for Oracle Driver problem
    ... I think I have a resource issue with this driver. ... we are having an issue where suddenly the ODBC ... customer on that hosted machine. ... Microsoft ODBC Driver for Oracle. ...
    (microsoft.public.data.odbc)
Loading