----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: bignbullish Message 4 in Discussion hi, I'm replying because i didn't get the answers for this question .... here it is again ..... If the Connection String used are different .... what is the impact of this difference on the connection pools created? I'm given to understand that when a connection is created, the exact matching algorithm would check the connection string and if it finds an existing connection with a matching connection string already present, then this new connection is added to it's connection pool. If the matching algorithm does not find a match, then a new connection pool is created for it. The first two connection strings, "Integrated Security=SSPI;Initial Catalog=pubs" and "Integrated Security=SSPI;Initial Catalog=northwind" are different and thus 2 connection pools, one for each shud be created .... correct me if i'm wrong. The third connection string is a bit different ... "Integrated Security=SSPI;Initial Catalog=mydb;Initial Catalog=northwind" here, the property "Initial Catalog" is repeated twice ... I'm given understand that in such a case, the value found at the last occurance of the property is considered i.e. Initial Catalog will be northwind ... so it's essentially similar to the second string. So, the connection from the third string shud share the connection pool of the second ... isn't it? But the strings themselves are different ... so will the exact match algorithm find a match? If it does, then there shud be 2 connection pools, else, 3. I hope i'm clear now ... do let me know what u think. -Raghu ----------------------------------------------------------- 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]
