Async Connection timed out

microsoft.public.dotnet.framework.adonet

1 Mar 2007 4:00 AM

apiringmvp

After reading Jeff Prosise article Scalable Apps with Asynchronous
Programming in ASP.NET (http://msdn.microsoft.com/msdnmag/issues/07/03/
WickedCode/default.aspx) in MSDN Magazine I was inspired to upgrade my
website to use async database calls. Everything is working from the
code standpoint, but I seem to be having an issue connecting to
SqlServer.

On my work computer everything works fine and published on the site
everything works fine

>From my home computer connected to the server I get a "Timeout

expired. The timeout period elapsed prior to completion of the
operation or the server is not responding." error. Everything works
fine if I take the async=true off and use the old non-async code.
Also wierd, when i'm connected to VPN, which should bypass all
firewall restrictions, I still get the server timed out error.

The Sql Server 2005 (9.0.1399) and IIS are installed on a Windows 2003
Server Std Ed in my office behind a firewall. The SqlServer has TCP/
IP, Named Pipes and Shared Memory all turned on.

connString
--------------------------------------------------
Data Source=www.servername.com;Initial Catalog=Northwinds;Persist
Security Info=True;User ID=user;Password=****;async=true;