General network error

  • Thread starter Thread starter stan
  • Start date Start date
S

stan

I have .net 2003 and SQL 2000 setup on one system. All I
have is one computer (no network). I am able to get to
the internet that works. I can run SQL Query Analyzer and
it works. The program was running fine. I did not make any
changes to the program or the stored procedures. But I am
now getting this error. I don't know what or where to
check for error.

General network error. Check your network documentation.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and where
it originated in the code.

Exception Details: System.Data.SqlClient.SqlException:
General network error. Check your network documentation.

Source Error:


Line 214:
Line 215: ' Execute the command
Line 216: myConnection.Open()
Line 217: Dim result As SqlDataReader =
myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Line 218:


Source File: C:\Market\Components\MaintenanceDB.vb
Line: 216

Stack Trace:


[SqlException: General network error. Check your network
documentation.]
System.Data.SqlClient.ConnectionPool.GetConnection
(Boolean& isInTransaction) +472

System.Data.SqlClient.SqlConnectionPoolManager.GetPooledCon
nection(SqlConnectionString options, Boolean&
isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
Market.MK.MaintenanceDB.GetworkQueues() in
C:\Market\Components\MaintenanceDB.vb:216
Market.maintDefault.Page_Load(Object sender, EventArgs
e) in C:\Market\maintDefault.aspx.vb:34
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +720
 
yes
-----Original Message-----
Hi stan,

Does it happen at first anytime Open() is invoked?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

stan said:
I have .net 2003 and SQL 2000 setup on one system. All I
have is one computer (no network). I am able to get to
the internet that works. I can run SQL Query Analyzer and
it works. The program was running fine. I did not make any
changes to the program or the stored procedures. But I am
now getting this error. I don't know what or where to
check for error.

General network error. Check your network documentation.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and where
it originated in the code.

Exception Details: System.Data.SqlClient.SqlException:
General network error. Check your network documentation.

Source Error:


Line 214:
Line 215: ' Execute the command
Line 216: myConnection.Open()
Line 217: Dim result As SqlDataReader =
myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Line 218:


Source File: C:\Market\Components\MaintenanceDB.vb
Line: 216

Stack Trace:


[SqlException: General network error. Check your network
documentation.]
System.Data.SqlClient.ConnectionPool.GetConnection
(Boolean& isInTransaction) +472

System.Data.SqlClient.SqlConnectionPoolManager.GetPooledCon
nection(SqlConnectionString options, Boolean&
isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
Market.MK.MaintenanceDB.GetworkQueues() in
C:\Market\Components\MaintenanceDB.vb:216
Market.maintDefault.Page_Load(Object sender, EventArgs
e) in C:\Market\maintDefault.aspx.vb:34
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +720
Click to expand...


.
Click to expand...
 
Hi,

Sounds like you are having trouble with either connection string or sql
client.
What does you connection string look like?
Can you try using the same connection string from a winform application?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

stan said:
yes
-----Original Message-----
Hi stan,

Does it happen at first anytime Open() is invoked?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

stan said:
I have .net 2003 and SQL 2000 setup on one system. All I
have is one computer (no network). I am able to get to
the internet that works. I can run SQL Query Analyzer and
it works. The program was running fine. I did not make any
changes to the program or the stored procedures. But I am
now getting this error. I don't know what or where to
check for error.

General network error. Check your network documentation.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and where
it originated in the code.

Exception Details: System.Data.SqlClient.SqlException:
General network error. Check your network documentation.

Source Error:


Line 214:
Line 215: ' Execute the command
Line 216: myConnection.Open()
Line 217: Dim result As SqlDataReader =
myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Line 218:


Source File: C:\Market\Components\MaintenanceDB.vb
Line: 216

Stack Trace:


[SqlException: General network error. Check your network
documentation.]
System.Data.SqlClient.ConnectionPool.GetConnection
(Boolean& isInTransaction) +472

System.Data.SqlClient.SqlConnectionPoolManager.GetPooledCon
nection(SqlConnectionString options, Boolean&
isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
Market.MK.MaintenanceDB.GetworkQueues() in
C:\Market\Components\MaintenanceDB.vb:216
Market.maintDefault.Page_Load(Object sender, EventArgs
e) in C:\Market\maintDefault.aspx.vb:34
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +720
Click to expand...


.
Click to expand...
Click to expand...
 
I can run SQL Query Analyzer and it works. I don't
understand what you mean.please email at (e-mail address removed)
-----Original Message-----
Hi,

Sounds like you are having trouble with either connection string or sql
client.
What does you connection string look like?
Can you try using the same connection string from a winform application?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

yes

-----Original Message-----
Hi stan,

Does it happen at first anytime Open() is invoked?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

I have .net 2003 and SQL 2000 setup on one system. All I
have is one computer (no network). I am able to get to
the internet that works. I can run SQL Query Analyzer and
it works. The program was running fine. I did not
Click to expand...
make
any
changes to the program or the stored procedures. But
Click to expand...
I
am
now getting this error. I don't know what or where to
check for error.

General network error. Check your network documentation.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and where
it originated in the code.

Exception Details: System.Data.SqlClient.SqlException:
General network error. Check your network documentation.

Source Error:


Line 214:
Line 215: ' Execute the command
Line 216: myConnection.Open()
Line 217: Dim result As SqlDataReader =
myCommand.ExecuteReader (CommandBehavior.CloseConnection)
Line 218:


Source File: C:\Market\Components\MaintenanceDB.vb
Line: 216

Stack Trace:


[SqlException: General network error. Check your network
documentation.]
System.Data.SqlClient.ConnectionPool.GetConnection
(Boolean& isInTransaction) +472
Click to expand...
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledCon
nection(SqlConnectionString options, Boolean&
isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
Market.MK.MaintenanceDB.GetworkQueues() in
C:\Market\Components\MaintenanceDB.vb:216
Market.maintDefault.Page_Load(Object sender, EventArgs
e) in C:\Market\maintDefault.aspx.vb:34
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +720



.
Click to expand...
Click to expand...


.
Click to expand...
 
Hi All

I'm new to this groups business and also to ADO.NET so forgive me if
this is not relevant...

I'm getting the following error message:
System.Data.SqlClient.SqlException: General network error

I have identified the following scenario in which it can occur - I
can't explain it but I hope it will add to the discussion in some way.

1. Open an asp.net page that connects to the database/retrieves some
data/closes connection.
2. Open up Sql Query Analyser and identify the relevant spid for the
asp.net page.
3. Kill the spid identified above
4. Try to reload the .aspx page - The error above is reported.
5. If I try to reload the page again, everything works fine.

Interestingly, it seems that despite the fact that an error is
reported in step 4 above, a spid is created although the LastBatch
DateTime (sp_who2) is set to 01/01 00:00:00. Upon execution of step
5, a new spid is created - almost as if the pooling mechanism is
unaware of the existing spid.

Cheers
Chris
 
i don't know how to Open up Sql Query Analyser and
identify the relevant spid for the asp.net page?
stan
 
Assuming you're using Microsoft Sql Server and that Query Analyser is
installed:

Start -> Programs -> Microsoft Sql Server -> Query Analyser will open
up the Query Analyser.

Login to the relevant Sql Server.

Once you're in, type in sp_who2 and press F5. This will bring back a
list of processes running on the Sql Server.

I found it easier to make my asp.net application login under a
dedicated username / password so that the processes concerned could be
easily identified.

However, the quickest way to identify the processes is to change your
connection string and add the application name entry:
eg
conPubs = new SqlConnection("server=localhost;uid=sa;pwd=;database=pubs;application
name=MYAPPLICATIONNAME");

If you run your ASP.NET page, and then do sp_who2 in Sql Query
Analyser, you will see that the penultimate column (Program Name) will
contain (in the example above) MYAPPLICATIONNAME. The spid for that
process is shown in the spid column. If you want to kill the process,
type in and run kill [spid] where [spid] is the id of the process
identified above.

Cheers
Chris
 
Back
Top