thanks Paul, I did not think tht a variable would be shared
application wide just because it was declared as static. I figured it
would be session wide, or "Per user instance". this is good to know
thanks Again

On Thu, 26 Jun 2003 22:51:09 -0400, "Paul Wilson [MVP]"
<Paul@WilsonDotNet.com> wrote:

That's exactly what static means -- its a global variable shared by
any and
all.
You should use session variables if you want something unique to a
user
session.

Anyhow, database connections should never be put into session or
statics.
You should instead open a connection when you need it and close it
fast too.
This simply releases it to the pool, so its very efficient and it
avoids
contention.

Thanks, Paul Wilson (MVP)