General network error

[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.Sql Client.SqlExcep tion:
General network error. Check your network documentation.

Source Error:
Line 214:
Line 215: ' Execute the command
Line 216: myConnection.Op en()
Line 217: Dim result As SqlDataReader =
myCommand.Execu teReader(Comman dBehavior.Close Connection)
Line 218:
Source File: C:\Market\Compo nents\Maintenan ceDB.vb
Line: 216

Stack Trace:
[SqlException: General network error. Check your network
documentation.]
System.Data.Sql Client.Connecti onPool.GetConne ction
(Boolean& isInTransaction ) +472

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledCon
nection(SqlConn ectionString options, Boolean&
isInTransaction ) +372
System.Data.Sql Client.SqlConne ction.Open() +384
Market.MK.Maint enanceDB.Getwor kQueues() in
C:\Market\Compo nents\Maintenan ceDB.vb:216
Market.maintDef ault.Page_Load( Object sender, EventArgs
e) in C:\Market\maint Default.aspx.vb :34
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +720

[Miha Markic]

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" <sm******@si.rr .com> wrote in message
news:03******** *************** *****@phx.gbl.. .

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.Sql Client.SqlExcep tion:
General network error. Check your network documentation.

Source Error:
Line 214:
Line 215: ' Execute the command
Line 216: myConnection.Op en()
Line 217: Dim result As SqlDataReader =
myCommand.Execu teReader(Comman dBehavior.Close Connection)
Line 218:
Source File: C:\Market\Compo nents\Maintenan ceDB.vb
Line: 216

Stack Trace:
[SqlException: General network error. Check your network
documentation.]
System.Data.Sql Client.Connecti onPool.GetConne ction
(Boolean& isInTransaction ) +472

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledCon
nection(SqlConn ectionString options, Boolean&
isInTransaction ) +372
System.Data.Sql Client.SqlConne ction.Open() +384
Market.MK.Maint enanceDB.Getwor kQueues() in
C:\Market\Compo nents\Maintenan ceDB.vb:216
Market.maintDef ault.Page_Load( Object sender, EventArgs
e) in C:\Market\maint Default.aspx.vb :34
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +720

[stan]

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" <sm******@si.rr .com> wrote in message
news:03******* *************** ******@phx.gbl. ..

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.Sql Client.SqlExcep tion:
General network error. Check your network documentation.

Source Error:
Line 214:
Line 215: ' Execute the command
Line 216: myConnection.Op en()
Line 217: Dim result As SqlDataReader =
myCommand.Execu teReader(Comman dBehavior.Close Connection)
Line 218:
Source File: C:\Market\Compo nents\Maintenan ceDB.vb
Line: 216

Stack Trace:
[SqlException: General network error. Check your network documentation.]
System.Data.Sql Client.Connecti onPool.GetConne ction
(Boolean& isInTransaction ) +472

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledCon nection(SqlConn ectionString options, Boolean&
isInTransaction ) +372
System.Data.Sql Client.SqlConne ction.Open() +384
Market.MK.Maint enanceDB.Getwor kQueues() in
C:\Market\Compo nents\Maintenan ceDB.vb:216
Market.maintDef ault.Page_Load( Object sender, EventArgs e) in C:\Market\maint Default.aspx.vb :34
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +720

.

[Miha Markic]

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" <an*******@disc ussions.microso ft.com> wrote in message
news:00******** *************** *****@phx.gbl.. .

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" <sm******@si.rr .com> wrote in message
news:03******* *************** ******@phx.gbl. ..

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.Sql Client.SqlExcep tion:
General network error. Check your network documentation.

Source Error:
Line 214:
Line 215: ' Execute the command
Line 216: myConnection.Op en()
Line 217: Dim result As SqlDataReader =
myCommand.Execu teReader(Comman dBehavior.Close Connection)
Line 218:
Source File: C:\Market\Compo nents\Maintenan ceDB.vb
Line: 216

Stack Trace:
[SqlException: General network error. Check your network documentation.]
System.Data.Sql Client.Connecti onPool.GetConne ction
(Boolean& isInTransaction ) +472

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledCon nection(SqlConn ectionString options, Boolean&
isInTransaction ) +372
System.Data.Sql Client.SqlConne ction.Open() +384
Market.MK.Maint enanceDB.Getwor kQueues() in
C:\Market\Compo nents\Maintenan ceDB.vb:216
Market.maintDef ault.Page_Load( Object sender, EventArgs e) in C:\Market\maint Default.aspx.vb :34
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +720

.

[stan]

I can run SQL Query Analyzer and it works. I don't
understand what you mean.please email at sm******@si.rr. com

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

Sounds like you are having trouble with either connection string or sqlclient.
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" <an*******@disc ussions.microso ft.com> wrote in messagenews:00******* *************** ******@phx.gbl. ..

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" <sm******@si.rr .com> wrote in message
>news:03******* *************** ******@phx.gbl. ..
>> 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.Sql Client.SqlExcep tion: >> General network error. Check your network documentation. >>
>> Source Error:
>>
>>
>> Line 214:
>> Line 215: ' Execute the command
>> Line 216: myConnection.Op en()
>> Line 217: Dim result As SqlDataReader =
>> myCommand.Execu teReader (CommandBehavio r.CloseConnecti on) >> Line 218:
>>
>>
>> Source File: C:\Market\Compo nents\Maintenan ceDB.vb
>> Line: 216
>>
>> Stack Trace:
>>
>>
>> [SqlException: General network error. Check your

network

>> documentation.]
>> System.Data.Sql Client.Connecti onPool.GetConne ction
>> (Boolean& isInTransaction ) +472
>>
>>

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledCon

>> nection(SqlConn ectionString options, Boolean&
>> isInTransaction ) +372
>> System.Data.Sql Client.SqlConne ction.Open() +384
>> Market.MK.Maint enanceDB.Getwor kQueues() in
>> C:\Market\Compo nents\Maintenan ceDB.vb:216
>> Market.maintDef ault.Page_Load( Object sender,

EventArgs

>> e) in C:\Market\maint Default.aspx.vb :34
>> System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
>> System.Web.UI.C ontrol.LoadRecu rsive() +35
>> System.Web.UI.P age.ProcessRequ estMain() +720
>>
>
>
>.
>

.

[Chris]

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.Sql Client.SqlExcep tion: 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

[stan]

i don't know how to Open up Sql Query Analyser and
identify the relevant spid for the asp.net page?
stan

-----Original Message-----
Hi All

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

I'm getting the following error message:
System.Data.Sq lClient.SqlExce ption: General network error

I have identified the following scenario in which it can occur - Ican'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 somedata/closes connection.
2. Open up Sql Query Analyser and identify the relevant spid for theasp.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.
Interestingl y, it seems that despite the fact that an error isreported in step 4 above, a spid is created although the LastBatchDateTime (sp_who2) is set to 01/01 00:00:00. Upon execution of step5, a new spid is created - almost as if the pooling mechanism isunaware of the existing spid.

Cheers
Chris
.

[Chris]

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=localhos t;uid=sa;pwd=;d atabase=pubs;ap plication
name=MYAPPLICAT IONNAME");

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) MYAPPLICATIONNA ME. 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

i don't know how to Open up Sql Query Analyser and
identify the relevant spid for the asp.net page?
stan