I have an asp application hosted on a web server that interacts with a sql server 7.0 db on a seprate db server. I also have a batch job running 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.
Any suggestions or ideas on what the problem may be would be appreciated..
Any suggestions or ideas on what the problem may be would be appreciated..
