network error

[Frank]

I have an application consisting of an Access 2002 database serving as the
front end, and a Microsoft SQL Server database holding the tables, as the
back end (SQL Server 2000, I believe). The application reads text files out
of a PC folder, processes the data, and posts the information to tables in
the SQL Server database.

The application runs fine for the fist x records, where x can be 100 to
several thousand, and then stops with the following error message:

Error: -2147467259 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL
Server does not exist or access denied.

This error only seems to happen when the application is running on a
network. We are using Windows NT Authentication for the network login ID in
the ODBC connection.

A search of the Microsoft Knoweldge Base found a couple of articles that
mentioned the error, but the conditions that Microsoft says are leading to
the error, don't seem to apply in our situation.

Any ideas?

 

[Arvin Meyer [MVP]]

The database must be split with the front-end running on a workstation and
the back-end properly connected with ODBC to the back-end (SQL-Server). Make
sure that you have enough record locks and that your connection is good.
Occasionally, if a NIC card is beginning to fail, you will notice that it
will begin dropping packets after initially working fine. You may want to
set up a perfmon.exe trace to watch and record the network traffic.

 

[Frank]

Arvin:

Thanks a bunch for your reply. Will look into your suggestions.