September 28, 2006 at 8:20 am
Greetings to all,
while running distributed queries, SQL server took a very long time and failed. We are receiving 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
Any help is greatly appreciated. Thank you in advance.
September 29, 2006 at 10:01 am
What is the remote server? Another SQL instance, an AS/400 or Oracle?.
November 1, 2006 at 9:15 am
I have the exact same issue. When I remove the distributed query it works. However in some cases I was about to modify the select statement to return all data (select *) and it came back without that error. In other cases a UDF was needed.
select i.itemi -- generates that error
select top 10* -- returns data
from dbo.table0 I with (nolock)
join db1.dbname.dbo.table1 IFI on I.Item1 = IFI.Item1
join db1.dbname.dbo.table2 FI on IFI.Item2 = FI.Item2
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply