Skip to content

Personal tools
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 site.
Tap into the potential of this DBA community to expand your business! Interested? Contact us today.
Who Are You?
I am a:
Mainframe True Believer
Distributed Fast-tracker

[ Results | Polls ]
Votes : 3559


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.

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.


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!

Powered by Plone