sql server connect: Connecting to Sql Server 2005 on Win2K3 Server -- sql server connect

Connecting to Sql Server 2005 on Win2K3 Server

rmgalante NO[at]SPAM yahoo.com
12/14/2006 6:14:17 AM

sql server connect:

Hello,

I have a Win2K3 Server running .Net Framework 2.0 applications. When I
run an application for the first time on a particular day, the first
connection takes an extremely long time to connect (60 seconds or
more). Other connections afterwards are fine.

I am running the application on the same machine as the db server. So
network issues should not be a factor.

I can connect with Sql Server Management Studio fine. As a matter of
fact, I can connect with Sql Server Management Studio first. But the
first time I run an application on any day, it takes an extremely long
time to connect. I am using the Enterprise Library Data Application
Block for data access in my applications. It's the January 2006 version
of the data application block.

Anyone know why this happens?

Thanks.

Re: Connecting to Sql Server 2005 on Win2K3 Server

Arnie Rowland
12/14/2006 3:32:45 PM

IT takes a while for the DAAB to obtain all of the metadata that it requires
to continue to function properly.

I suggest that if you can't live with the 'setup' time issue, that perhaps
you should investigate direct connections using stored procedures instead of
the DAAB.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

[quoted text, click to view]