SQL server 2000 throws General network error sometimes when I try to update values. The behavior is quite random (I m not even able to reproduce it. Only way, I know about this error is thru log file, as application is configured to log all the errors in a log file) Sometimes, It happens at one place and sometimes at the other. But the common thing is it always happens when I try to call fill for adapter object. I mean it works fine for executing stored procedures. I tried googling for the solution of the same and found a couple of suggestions to try. Like increasing command timeout, removing pool settings etc.
http://weblogs.asp.net/pleloup/archive/2003/07/23/10451.aspx
http://dotnetjunkies.com/WebLog/rtgurskevik/archive/2005/03/03/58301.aspx
Only thing which seems to be working is removing pool settings from web.config (as I did not see that error occurring after this). but again that’s quite weird solution as I know that gonna directly impact the performance of the system. Can anyone suggest some better solution or at least the possible cause of the problem?
Monday, June 12, 2006
Subscribe to:
Post Comments (Atom)
1 comment:
good work sachin. its good way to collect your notes. you can also give a try to google notebook a nice software.
Post a Comment