Sql – General Network Error accessing SQL Server 2005 from Access 2000

ms-accesssql serversql-server-2005

We are encountering problem in using Access 2000 (.ADP) as our front-end and SQL 2005 as our back-end and we have more then 50 users:

[DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.

It was working fine for the last years, but now the system keeps kicking out the user. They always receive an error "[DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation."
Any idea why is this happening or what is the best solution that we can do?
Thanks in advance.

Best Answer

Kicking out the user after it connects to the server? Does it happen randomly, or after a certain operation? Does the server even sees the connect attempt (Profiler connect events)? Check out the SQL Server LOG folder on your server. See if you find any .mdmp files, or files named sqldump*. Also look into the ERRORLOG file(s) and see if you find any message that can be correlated with the moment when the client receives that error.

Related Solutions

Sql – Access 2000 connecting to SQL Server 2005

I've had a similar problem before when using ODBC linked tables to connect to an Sql Server. The solution was to relink the tables and specify the primary key to the table. If Access doesn't know the primary key it cannot perform inserts or updates.

I haven't any experience with ADPs but it could be a similar thing, theres a knowledge base article about it here http://support.microsoft.com/?scid=kb%3Ben-us%3B235267&x=15&y=13

Sql – How to return only the Date from a SQL Server DateTime datatype

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, @your_date))

for example

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

gives me

2008-09-22 00:00:00.000

Pros:

No varchar<->datetime conversions required
No need to think about locale

Best Answer

Related Solutions

Sql – Access 2000 connecting to SQL Server 2005

Sql – How to return only the Date from a SQL Server DateTime datatype

Related Topic