data connection in the global.aspx file, instead of multiple connections,
but can not recall why.
I can't imagine this being a viable option in most cases.
Also is there a lot of overhead with multiple connections?
Yes and no. There's overhead associated with opening and closing
connections and transferring data, but there's no way around this..if you
want multiple users this is going to happen. The real problem starts if you
don't close your connections. If you don't they aren't returned to the pool
and you can possibly run out of them. If you turn on pooling (which is on
by default) and close your connections when you are done with them, you
should be good to go.
I did a search but did not find anything. Thanks.
W.G. Ryan, eMVP