Re: network error
- From: "Arvin Meyer [MVP]" <a@xxxxx>
- Date: Sat, 25 Nov 2006 19:44:46 -0500
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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
"Frank" <fhsmith7@xxxxxxxxxxxxx> wrote in message
news:_o3ah.16636$K9.6907@xxxxxxxxxxxxxxxxxxxxxxxxx
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?
.
- References:
- network error
- From: Frank
- network error
- Prev by Date: Re: moving a main form and subform to a specific subform record
- Next by Date: Re: can't see new records on sub form
- Previous by thread: network error
- Next by thread: Re: network error
- Index(es):
Relevant Pages
|
