Re: Communication link failure

How you address it depends partly on how you are access the
SQL 2000 database, what this operation does that you are
retrying.
Just a guess but if this is linked tables, then you should
create some VBA function in Access to relink (not refresh)
the tables in code. Then you can try executing this function
instead.

-Sue

On 16 May 2006 03:17:49 -0700, saikosounds@xxxxxxxxx wrote:

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: Migration recommendations; PRELIMINARY INQUIRY
    ... already mentioned is SQL. ... Behalf Of Mark Wonsil ... network or hierarchical databases. ... In a hierarchical database, a child set can only have one parent. ...
    (comp.sys.hp.mpe)
  • Re: Sql Server 2000; TCP/IP vs named Pipes
    ... I do not beleive it is a DB as in database problem. ... go over the network, so if there is a general network overutilization issue ... Analyzer from desktops and connect (specifying both named pipes and tcp/ip ... My company is running an application that uses sql server 2000 sp3. ...
    (microsoft.public.sqlserver.connect)
  • Re: Access 2007 ADP (Runtime) and SQL Express 2005
    ... To stop Access trying to connect to a database as soon as the application ... Although I can resolve this on my network, what worries me is when I'm ... create new runtime and install it on some 10 to 15 Pc, plus the SQL ... database on the client server. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access Tables -- Size and Issues
    ... You might consider moving all of the historical data tables onto a SQL ... the database can remain at these huge sizes for days or even weeks. ... >> information is on the network already and needs to remain there, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
Loading