I have just started on a new web project. When I make the first connection
to sql server it takes about 10 to 30 seconds (varies each time) to make the
connection to the server. I am using the following code:
Dim cConnStr as String = "myconnectionstring"
Dim oCon as new SqlConnection(cConnStr)
oCon.Open() <-- Slow part
The Open line takes quite a long time.
I can use the exact same code in a windows app with exact same connect
string and it runs immediately on the same machine.
Any ideas what is going on?
I am running XP Pro SP2 and I tried disabling the firewall but it didn't
change anything. I didin't have this problem before I upgraded to Sp2.
Thanks.