ChongQing Xiao [mailto:[EMAIL PROTECTED]] wrote:
> In ADO.NET, the connection pool will be used if the > connection string is the same. This works fine > if I can map many different user to the same userID in the > Database. But how it will work if I want to distinguish > different user in the database (say for audit purpose)? If I > map one end user to one database user, can the connection > still be reused? They can't be shared between database users anymore because the connection has been established with the set of creditials supplied. So, each database user will have their own pool (puddle?) of connections. HTH, Drew You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
