"from the time you open it in your init code all the way until the last person is done using it."
What I do is open it just before I use it, then when I am done using it, I dispose of it. All in the same method. How can this be multi persons? Example: Create Connection object open connection Create transaction Execute SP1 Execute SP2 Execute SP3 commit transaction close connection dispose connection object You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
