I have an asp application hosted on a web server(win 2k) that interacts with a sql server 7.0 db on a seprate db server (nt 4.0). I also have a batch job running (vb app) as a task on the webserver that is talking to the Db server performing various functions. I am using an sqloledb connection with this batch job to talk to the db. 95% of the time the batch job functions run fine, but occasionally I came across an error that occurs in one of the functions, with the following description "[DBMSSOCN] General network error. Check your network documentation." and this causes the said function to die before completion. I know this because it is supposed to be updating a set number of records yet when it occurs it does not update the full 36 records it is supposed to. There is no rhyme or reason as to when it fails as sometimes it fails during heavy volume use and even during minimal use, and the number of records it completes updating before it crashes is random as well.
This error also occurs in any of the 4 possible functions within the vb app, all doing compeltely serperate things, which leads to believe the problem lies somewhere other than code.
Here is my connection string, values substituted of course:
Provider=SQLOLEDB;Data Source=220.127.116.11;Initial Catalog=DBNAME;User ID=SA;Password=password;Connection Timeout=30
ny suggestions or ideas on what the problem may be would be appreciated..