GeneralOctober 6, 2005 9:12 am
General network error. Check your network documentation
I got this error while executing SP on database. We are using connection pooling in the connection string. As the number of people are trying to connect to the same database while debugging the application - this error was coming. As soon as the debug of some person stops, same code is working fine. Here is a Microsoft KB : http://support.microsoft.com/default.aspx?scid=kb;en-us;827452 Here is a nice discussion on the issue: http://weblogs.asp.net/pleloup/archive/2003/07/23/10451.aspx
Read More Articles
Comments
“General Network error ……….”
This error message really got me worked, but fortunately i was able to find the reason.
To replicate the error you need to have SQL Server Management Studio (2005) may be with SQL Server 2000 it is Enterprise Manager, but not MSDE.
You may create a small VB.NET app using the following code
Dim conn as SqlConnection
Dim cmd as SqlCommand
‘ Remember to change values between []
Try
conn = New SqlConnection(”Data Source=” + [Your Server Name] + “;Integrated Security=false; User ID=” + [Your User Name] + “;Password=” + “Your Password” + “;”)
conn.Open()
cmd = New SqlCommand
cmd.Connection = conn
cmd.CommandText = “CREATE DATABASE [aftermarket]”
cmd.ExecuteNonQuery()
Catch ex As SqlException
Console.WriteLine(ex.Message)
‘ OR following if under Winforms
MessageBox.Show(ex.Message)
Finally
conn.Close()
End Try
OR
You may create a small C# app using the following code
SqlConnection conn;
SqlCommand cmd ;
try
{
// Remember to change values between []
conn = new SqlConnection(”Data Source=” + [Your Server Name] + “;Integrated Security=false; User ID=” + [Your User Name] + “;Password=” + “Your Password” + “;”);
conn.Open();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = “CREATE DATABASE [MyDatabase]”;
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
// OR following if under Winforms
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
Compile and run the app, hopefully a Database named “MyDatabase” will be created
Now start SQL Server Management Studio (for 2005) or Enterprise Manager (for 2000) and delete the Database just created, now run the app created earlier, you might get the dreaded error message, try to run the app atleast 3 times you will get the same error message.
Now question is , how do i correct the problem, simple - Reboot the system and try running the app again.
Indeed a painful way of overcomming an error message.
This error message ONLY show up when you have, and has no connection with the Timeout property.
Integrated Security=false
User ID=[Your User Name]
Password=[Your Password]
Note: This is Microsofts general-purpose error message and this solution may not work in all cases.
Barretto
Comment by Barretto VN — July 15, 2007 @ 2:53 pm