I recently converted an application that uses Access 2003 for Frontend
and Backend to Access 2003 FE / SQL 2005 Express BE. The tables are
linked with a DSN-less connection via SQL Native Client.
Several Customers use this application and some of them re****ted a
dramatic increase in connectivity related errors. Most often this one:
ODBC-connection to 'SQL Native Client[MyServerName\MyInstanceName]'
failed
It seems to be the result of network problems, but the old version of
the programm was doing ok.
I did a few tests and discovered that if there is no answer from the
network for about 7 seconds the next query to the SQL-Server will fail
- even if the network is responding again at that time.
Is there anything I can do, other that tell the customers to hire a
professional to analyse and fix their network?
