DBAzine.com

Sections

Personal tools

You are not logged in
Log in
Join

You are here: Home » SQL Server » SQL Server Articles Archive » Connection Pooling and Connection Management » conflicting pooling ideas

Seeking new owner for this high-traffic DBAzine.com site.
Tap into the potential of this DBA community to expand your business! Interested? Contact us today.

Who Are You?

I am a:
[ Results | Polls ]
Votes : 3559

Comment

Above in this comment thread: Connection Pooling and Connection Management » Thank you

conflicting pooling ideas

Posted by guerven at 2006-12-04 03:36 AM

Question 1: True or False: Changing the connection string, even slightly, will force a new connection.
False.

You don’t believe me? You’re a skeptic. Good. This is a common misconception. Many sources report that modifying even a single space in your connection string will force new connections to be created. While it is true that modifying the credentials of a connection string will create a new connection, shuffling the parameters around will not. SQL simply verifies that the user, password, and database are the same for a connection request to be eligible for pooling.

source
http://www.sql-server-performance.com/sk_connection_pooling_myths.asp

ano ba kuya! ano ba talaga!

Transaction Management
Reduce downtime and increase repeat sales by improving end-user experience.
Free White Paper

Database Recovery
Feeling the increased demands on data protection and storage requirements?
Download Free Report!