473,569 Members | 2,692 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

System.Data.Sql Client.SqlExcep tion: General network error ????

HK
I just moved an ASP.NET application to a new web server at a different
location of ours. The SQL Server machine was moved to that new location at
the same time as the web site DNS was pointed to the new server. Suddenly
I'm getting lots of intermittent errors of this type.

The switch/hub/repeater that routes the traffic at the new location is an
older one, if that makes any difference.

One thing that bothers me is that the SQL Server has since (the move) been
reporting NetBT errors in the event log (event ID 4319 "A duplicate name has
been detected on the TCP Network"). But there are no duplicate names on my
private tcp/ip network. I can only think that maybe that comes from the
fact that I am using an external public DNS server on the sql server now;
before I think I had it pointed at its own internal DNS service on the same
box. I don't know if this error is related.

The ASP.NET error is:

System.Data.Sql Client.SqlExcep tion: General network error. Check your
network documentation.
at System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or behavior)
at Microsoft.Appli cationBlocks.Da ta.SqlHelper.Ex ecuteReader(Sql Connection
connection, SqlTransaction transaction, CommandType commandType, String
commandText, SqlParameter[] commandParamete rs, SqlConnectionOw nership
connectionOwner ship)
at Microsoft.Appli cationBlocks.Da ta.SqlHelper.Ex ecuteReader(Str ing
connectionStrin g, CommandType commandType, String commandText,
SqlParameter[] commandParamete rs)
at Microsoft.Appli cationBlocks.Da ta.SqlHelper.Ex ecuteReader(Str ing
connectionStrin g, CommandType commandType, String commandText)
at myprogram.mycla ss.mymethod()
the method names vary and work intermittently; they are also methods calling
stored procs that are optimized and execute quickly from Query Analyzer.
Any thoughts/fixes?
Nov 19 '05 #1
1 2905
"HK" <re************ **@notreal.com> wrote in
news:ZX******** **********@torn ado.socal.rr.co m:
I just moved an ASP.NET application to a new web server at a different
location of ours. The SQL Server machine was moved to that new
location at the same time as the web site DNS was pointed to the new
server. Suddenly I'm getting lots of intermittent errors of this
type.

The switch/hub/repeater that routes the traffic at the new location is
an older one, if that makes any difference. Any thoughts/fixes?

You're having network issues - time to get your network guru to debug your
network.

Nothing you can do about it in ASP.NET... basically .NET is having trouble
connecting (or maintaining a connection) to your SQL Server due to network
issues.

--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
3168
by: stanley j mroczek | last post by:
System.Data.SqlClient.SqlException: General network error. Check your network documentation. I know that this is not much to go on. But I don't know where to start. the program updates 186 records and on the 187 record I get this error. I know this don't make any sense but the code field has sa in it? When it bombs I have this in the...
2
2115
by: Kalyan | last post by:
Hello, System.Data.SqlClient.SqlException: General network error. Check your network documentation. What does this error means? My web app, suddenly started to show this error today in my production environment, beta environment, development environment, and also on my machine too. When i debugged the app, i see that the error is...
1
4581
by: Kal | last post by:
Hello, System.Data.SqlClient.SqlException: General network error. Check your network documentation. What does this error means? My web app, suddenly started to show this error today in my production environment, beta environment, development environment, and also on my machine too. When i debugged the app, i see that the error is...
2
4567
by: Chris Langston | last post by:
I have a Web Server running IIS 5 or 6 on Windows 2K and Windows 2003 Server that is experiencing strange shutdown problems. We are using ASP.NET v1.1 and our application is written in VB.NET Here's the scenario: 1. .NET Windows Client on a remote machine makes a web service call to update tables on a Web Server running SQL Server...
5
6574
by: Rod | last post by:
I have a client site where the code below has been working happily for at least four months. The site is using SQL Server 7. The code is ASP.NET Last week an error appeared related to the following SQL statement. INSERT INTO OrderItems (ClientID, ProductID, OrderHeaderID, Quantity, Dispatched, BackOrdered) SELECT ClientID, ProductID,...
3
15338
by: Rampa | last post by:
hello! the problem is always the same but i can't understand why it happens!! Someone can help me? FIRST QUERY GOES WELL, SECOND BREAK WITH ERROR why? Dim connessione As New SqlClient.SqlConnection("Server=SOSQLSRV01;Initial Catalog=SO_Bolle;Uid=SO_CattolicaRE;PWD=sogeda") Dim iddestinatario As Integer Dim...
3
24227
by: weird0 | last post by:
This is the exception that I get when i create a webserivce obj and call. The error comes on the webmethod call, when it opens a connection to the db. How do I fix it? What is the solution to this? System.Web.Services.Protocols.SoapException: Server was unable to process request. ---System.Data.SqlClient.SqlException: An attempt to...
2
2189
by: Carol | last post by:
Exception may be thrown in the code inside the try block. I want to handling the SqlException with State == 1 in a special way, and for all others I want to use a general way to handle. Which of the following options is better? ----------------------------------------------------- Option 1: try{...} catch (System.Data.SqlClient.SqlException...
2
4717
by: lily86 | last post by:
i'm very new so i hope all of u can help me. when i debug my webforms this error occur "An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error." pls help me solve the problem...thanks.. my code: Imports System.Data.SqlClient Imports System.Data.OleDb Imports...
0
7698
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7612
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
6284
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5219
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3653
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3640
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1213
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
937
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.