troubleshooting Question

Receiving DBMSSOCN General Network Error ??

Avatar of papa-smurf
papa-smurf asked on
Microsoft SQL Server
3 Comments1 Solution1533 ViewsLast Modified:
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=1.1.1.1;Initial Catalog=DBNAME;User ID=SA;Password=password;Connection Timeout=30

ny suggestions or ideas on what the problem may be would be appreciated..
ASKER CERTIFIED SOLUTION
robrien6

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros