error message: "General network error. Check your network documentatio

[igor22]

I am getting the error below when I try to bind data to a drop down box using data adapter. This error is random. I have been getting the same type of error when I used data reader. Anyone knows how to prevent these generic network errors?


----------------------------------------------------------------------------------------------

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:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +45
System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
NSBOHotels.NSBOHotelsP1.getClientList() in C:\Inetpub\

http://wwwroot\project\P1.aspx.vb:144

NSBOHotels.NSBOHotelsP1.Page_Load(Object sender, EventArgs e) in C:\Inetpub\

http://wwwroot\project\P1.aspx.vb:73

System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

 

[obislavu]

1. Check to see which permissions the user that connect to the DB has on the objects you are accessing (tables, views, functions, stored procedures). Maybe you do a select on a table where the user is not granted for select.
2. Try to find out the exact query string that is sent to the DB and inspect it and after that execute this query under the same user using SQL Query.
3. Could be a problem that is not related with your app but with some setting on the DB catalog that app accesses.

-obislavu-

 

[chiph]

4. Could genuinely be a network problem. Check with your IT staff. You might also want to use the SQL Client utility to force your connection to the database to use TCP/IP, instead of allowing the SQL client libraries to choose a protocol.

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first

 

[Kris11]

This is one error that we always get from our laptop users and the reason was that, by mistake they will un-plug the laptop from the network and without realizing that user hits save when prompted to save changes and the app throws this message. So we found that .NET throws this message if the
1. Connection to DB/network is not avaiiable.
2. Actually if your DB connection is down
3. Your network connection is down.

To know which of one of these three are causing the error, you might have to add additional specific exception handlers to your routine.

-Kris