Distributed Queries failed

  • 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.

  • What is the remote server? Another SQL instance, an AS/400 or Oracle?.

  • 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

    fromdbo.table0I with (nolock)

    join db1.dbname.dbo.table1 IFI on I.Item1= IFI.Item1

    joindb1.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