G
Guest
Not sure if this is the right place but hopefully someone can help. I have an Access project that runs fine on 17 machines but on the 18th it keeps popping the following error once or twice during the day on an update: [DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error. Check your network documentation
All the machines are running Windows and Office (sp2) XP and are identical hardware wise. The backend is SQL Server 2000 sp3a running on a Win2003 cluster which has been very stable. I suspect network connectivity even though one of our techs tested the nic and network connection and didn't find anything wrong. I can reproduce the problem by putting a break point in one of the procedures, unplugging the network cable then the old F5 to a break point in the error trap. At this point (I think this is really weird) when I query the connection state it shows still connected! CurrentProject.IsConnected returns true, Connection.State and AccessConnection.State both return 1
Anyway, my question is: Is there some way to programmatically force a reconnect? CurrentProject.CloseConnection doesn't seem to work and when I try OpenConnection it says I can't do it because the connection is already open (this is after I plug the cable back in). Any advice would be appreciated.
All the machines are running Windows and Office (sp2) XP and are identical hardware wise. The backend is SQL Server 2000 sp3a running on a Win2003 cluster which has been very stable. I suspect network connectivity even though one of our techs tested the nic and network connection and didn't find anything wrong. I can reproduce the problem by putting a break point in one of the procedures, unplugging the network cable then the old F5 to a break point in the error trap. At this point (I think this is really weird) when I query the connection state it shows still connected! CurrentProject.IsConnected returns true, Connection.State and AccessConnection.State both return 1
Anyway, my question is: Is there some way to programmatically force a reconnect? CurrentProject.CloseConnection doesn't seem to work and when I try OpenConnection it says I can't do it because the connection is already open (this is after I plug the cable back in). Any advice would be appreciated.