SQL Server Performance Forum – Threads Archive
General Net work Errorhi all,
While selecting some records from a table i’m getting the following error in query analyser.even i re-run same query it throws the following error. [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation. Connection Broken Please tell me the possible solutions.I’m totally worried with these errors. I searched in net. I got the below link. http://support.microsoft.com/default.aspx?scid=kb en-us Q317852 but that page was moved.
plz give the solution. Regards, Lalitha.C
Can you please check SQL Server error log file for stack dump information. Run DBCC CheckDb for this database and let us know if it print errors in result pane.
Deepak Kumar –An eye for an eye and everyone shall be blind
Add the servername or the IP address (with alias name) in the client network utility on your machine and then try it.
I agree, there are strong chance that connection broken error can be solved out by : – Adding the servername or the IP address (with alias name) in the client network utility on your machine and then try it. Deepak Kumar –An eye for an eye and everyone shall be blind
Actually i don’t know how to see the error log file.
Just i run the DBCC CheckDb command in queryanalyzer.
since 20 mins it is still in run mode. Regards Lalitha.C
How big the database size is..?
you can view SQL Error logs from
Open Enterprises Manager window
select SQL Server, and expand
Expand Managment folder
Expand SQL Server Logs
click on ‘Current…’ and read from right side pane 2.
From SQL installation directory, search for Log folder.. inside you will find .txt files for current and archive SQL error logs. — While DBCC is going try for : Adding the servername or the IP address (with alias name) in the client network utility on your machine and then try it. Deepak Kumar –An eye for an eye and everyone shall be blind
if you are on SP4 for 7.0, shouldn’t your version number be 7.00.1063? I believe this is correct. See if installing the latest SP works. Also, you should make sure you have an up-to-date MDAC on the client or application. I’m assuming since you’re running on 7.0, you’re probably using an old RDO connection? Give us a little more details about your setup if this doesn’t help.
Link http://support.microsoft.com/default.aspx?scid=kb;en-us;Q317852 says To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
See whether this helps http://sqljunkies.com/WebLog/orfda/archive/2003/10/22/295.aspx
Madhivanan Failing to plan is Planning to fail
I tried by giving remote IP Address in my system sqlserver enterprise manager Server Network utility with alias name.
Still it is giving error.
My database size is : 22344.06 MB Regards, Lalitha.c
which version of SQL Server you are using..? can you run select @@version and post the output.. Deepak Kumar –An eye for an eye and everyone shall be blind
Microsoft SQL Server 2000 – 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: ) Lalitha.C
Lalitha, Refer this http://support.microsoft.com/default.aspx?scid=kb;en-us;294338 Madhivanan Failing to plan is Planning to fail