general network error check your network documentation sql server 2000 West Edmeston New York

Installation of Voice & Data Cabling, Category 6, 5E, Fiber-Optics Installation of Panasonic Telephone & Voice Mail Systems & Products

* Business Telephone Systems * Computer and Network Cable * Equipment * Installation * Panasonic * Supplies * Telephone and Voice Mail Systems We Service Syracuse and Surrounding areas: * Binghamton * Endicott * Rochester * Vestal

Address 901 Hiawatha Blvd W, Syracuse, NY 13204
Phone (315) 469-5215
Website Link http://www.allpurposetelephone.com/home.html
Hours

general network error check your network documentation sql server 2000 West Edmeston, New York

share|improve this answer answered Jul 9 '10 at 10:31 Alex K. 106k16148194 No... Checking if the database connection is open (in the client code) returns true. You cannot post or upload images. Getting this error intermittently: System.Data.SqlClient.SqlException: Timeout expired.

Come on over! How exactly does the typical shell "fork bomb" calls itself twice? Karger's Algorithm question What is the first movie to show this hard work message at the very end? at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() After getting a fair number of these errors I get this one also: System.Data.SqlClient.SqlException: General network error.

Turn on more accessible mode Turn off more accessible mode Skip Ribbon Commands Skip to main content This page location is: KBSolution23Pages54349623 Sign In Log In | Sign Up | Log I am thinking about switching from the sql server to something more robust... It's completely reliably reproducible. For a long time our software was blamed on it until I wrote a simple VB script routine that runs in a loop and remains permanently connected and executes a simple

Everything else is working, there are no errors in the event log on sql server. Check out the SQL Server LOG folder on your server. Or otherwise consider it as a possible network problem? –John Saunders Jul 9 '09 at 19:53 It sure looks like a network problem. –Otávio Décio Jul 9 '09 at What sense of "hack" is involved in "five hacks for using coffee filters"? 5008 out of the box more hot questions question feed lang-sql about us tour help blog chat data

I've experienced this problem when the user was a member of a vast amount of groups. Also look into the ERRORLOG file(s) and see if you find any message that can be correlated with the moment when the client receives that error. but the error isn't intermittent. The code would not tell you anything it is just an update statement but here it is: Thanks for the code.

As for the statement - I know exactly what stored procedure it is timing out on and it is the same procedure that's working just fine the rest of the time. It gives a solution for you. After that the connections get reset and everything works fine for the whole day. Compute the kangaroo sequence Why did my electrician put metal plates wherever the stud is drilled through?

I looked at errors log too - there are no errors. My first concern is the error is not coming for all the report (web page). Reply kumaronasp None 0 Points 3 Posts Re: General network error. We even ran the script on the database server itself and it would happen there as well.

I looked at the locks, I did the profiling - I can't profile all day since it's a production server, but I can get a 5 minutes or so when the Check your network documentation. So, if a database connection is kept alive for a long time (used or unused) by the application, the underlying TCP/IP connectivity can get broken. I found one more thing...

Copyright © 2002-2016 Simple Talk Publishing. http://support.microsoft.com/kb/942861/en-us Another work around we tried and succeeded in our project was as follows: There is something called Network Speed setting which is usually set toAUTO or a fixed value. OK. However, performing any operations on that connection results in a General network error.

You cannot delete your own events. KRW Starting Member USA 3 Posts Posted-07/19/2005: 12:33:30 We are experiencing the same - Would like to know - SQL SErver 2000 on WIN 2003 -- when application is First I'll try to reproduce the problem with Crystal out of the equation.I also tried the SynAttackProtect registry hack (http://support.microsoft.com/default.aspx?scid=kb;en-us;899599) - this also had no effect.We're a certified MS partner, and I looked at the locks, I did the profiling - I can't profile all day since it's a production server, but I can get a 5 minutes or so when the

To quote the renowned Kermit The Frog: "No gnus is good gnus!" Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Customer will loom to replace the workstation (XP) that holds the database. That is not the event log. rmench Starting Member USA 1 Posts Posted-08/22/2006: 18:13:34 How did this work our for you?

Since it's a backend server app this is a normal scenario. How do I say "best practice" in Esperanto? Could you post the output of "SELECT @@version"? Everything else is working, there are no errors in the event log on sql server.

Reply Follow UsArchives January 2011(1) July 2010(1) June 2010(1) May 2010(1) January 2010(1) December 2009(1) November 2009(2) August 2009(2) July 2009(1) March 2009(1) All of 2011(1) All of 2010(4) All of It appears if and only if there has been a prolonged (several hours at least) idle time. –Vilx- Jul 9 '10 at 10:54 add a comment| Your Answer draft saved The investigation is on-going. at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() SQL connection pooling is turned off.

You may read topics. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! reading through the definition of `\cfrac` in AMSMath Word for someone who keeps a group in good shape? | Search MSDN Search all blogs Search this blog Sign in Ramoji Ryali's Fundas Ramoji Ryali's Fundas The interesting things I experimented with SQl Server.