Solved

If I have multiple databases in my SQL Server.  Can some other program effect the connection pool?

Posted on 2007-11-28
3
217 Views
Last Modified: 2010-03-19
If I have multiple databases in my SQL Server.  Can some other program effect the connection pool?

I am sharing a SQL server with multiple databases.  I use Try and Catches when ever I open a connection and dispose of it properly.

On the same server there are other databases, that another program uses.  Can that effect my connection pool?

I get a Timeout, that connection pool max has reached its limits.
0
Comment
Question by:mmedi005
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
Yveau earned 500 total points
ID: 20368165
No, when you define a connection pool, that will only be used by the app that defined it. No other app can 'ride' the connection pool. It has to make its own connection(pool) to get access to SQL Server.

Hope this helps ...
0
 

Author Comment

by:mmedi005
ID: 20368529
it does, thanks....
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20368633
Glad I could be of any help and thanks for the grade !
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ASP.NET Calendar Control 5 49
Record locking on classic ASP 3 59
CSS question 16 61
Difference between Leaflet and MapBox? 5 43
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question