----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Anjana-Techie Message 11 in Discussion Hi, As said same conn cannot be opened thrice...so this code would generate ar error. But suppose different connection objects are used then I think 2 connection pools would be created. The first would connect to northwind database. The third connection would also connect to northwind database (the first initial catalog would be ignored) The second connection string is different from the rest So in combination 2 connection pools would be created. (It's only a myth that a connection pool will be created everytime the string changes even a bit or if it is case sensitive. Pool manager only checks for username, password and database and ofcourse some other imp. credentials. Check this article for reference. http://www.sql-server-performance.com/sk_connection_pooling_myths.asp ) Regards Anjana ----------------------------------------------------------- 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]
