Re: Changing Query behavior based on local vs. remote context?
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 16 Aug 2007 22:28:04 +0000 (UTC)
Geoff N. Hiten (SQLCraftsman@xxxxxxxxx) writes:
Sounds like larger network packets are getting dropped. Some bridges that
do not do packet splitting can cause this.
Keith's description reminds me of a very weird error that a formed DSL
provider of mine had. I was mainly reading my after a holiday in SSH2
connection to a Unix account. And that worked fine. But then I got the
idea to look at some web site, but I could not access it. Tried another.
Did not work. A third one. Eventually I tried running lynx from the Unix
account. And that hung too! But I could open a new connection and read my
mail.
Finally I came around to put a very short text file on my web site, and
sure enough, this page did turn up in the browser. So I concluded they
had an error where split packets got lost, but as long as the packets
were small, things worked.
(The reason this provider is a former provider, is simply because I moved
to a new flat, and they could not deliver DSL there.)
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: Changing Query behavior based on local vs. remote context?
- From: Geoff N. Hiten
- Re: Changing Query behavior based on local vs. remote context?
- References:
- Changing Query behavior based on local vs. remote context?
- From: Keith
- Re: Changing Query behavior based on local vs. remote context?
- From: Geoff N. Hiten
- Changing Query behavior based on local vs. remote context?
- Prev by Date: Re: Changing Query behavior based on local vs. remote context?
- Next by Date: Re: default schema (SQL Server 2005)
- Previous by thread: Re: Changing Query behavior based on local vs. remote context?
- Next by thread: Re: Changing Query behavior based on local vs. remote context?
- Index(es):
Relevant Pages
|