• I found this FAQ entry at 15 Seconds that recommends putting the largest column returned last in the select list. This would include making sure that text and image columns are last too.

    http://www.15seconds.com/faq/ODBC/692.htm

    If that doesn't work, post your connection string. I doubt this is a problem with the query (unless the above comment helps) since you're getting network-related errors. You might also need to get a Network Engineer to look at the network activity. You mentioned that the two machines were on different networks and there could be any number of problems between the two computers.

    Also try searching Google for "sql server" "Communication link failure" (include the quotes). I found a bunch of things but you may find something more specific to your problem. I will keep tabs on this thread so reply after you try rearranging your query.

    [font="Tahoma"]Bryant E. Byrd, BSSE MCDBA MCAD[/font]
    Business Intelligence Administrator
    MSBI Administration Blog