----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: __GauravKhanna__ Message 7 in Discussion Hi! I am not so sure of the myth as is projected, because if you see how the SqlConnection.Open is implemented, you will see a totally different story. Allow me to the be story teller... When Open is invoked and and pooling is requested [yes, you got to request it as part of the connection string options!], the SQL Client attempts to get a connection from the pool on the basis of connection-string and connection-options specified. The SqlConnectionPoolManager produces a modified connection-string if Integrated Security is requested, and then passes on this modified connectiong-string [which will contain the Windows user-name] to locate a connection from the pool. The PoolManager then proceeds to use the specified connection-string as a key to a hash-table that maintains the ConnectionPools. Now that you know that connection-string is used as a key into a hash-table, and knowing that a key like "Integrated Security=SSPI;Initial Catalog=pubs" will be different that "Initial Catalog=pubs;Integrated Security=SSPI", your question gets answered: for the three connection-strings, that are radically different from each other, there will be three connection pools created. Hope that helps! Gaurav ------------------------------------------------------------------------ Microsoft MVP - C#/.NET WinToolZone - Spelunking Microsoft Technologies http://www.wintoolzone.com/ OpSupport - Spelunking Rotor http://opsupport.sscli.net/ ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
