"Verify Connection" connection string property

bozr · Post by **bozr** » Tue 06 Mar 2012 09:12

Hi,

I've got a question about the "Verify Connection" connection string property.
When I set this property to true in my connection string always get exceptions saying "Trying to put a closed connection to pool".

When I look into the documentation, I see that it should check the connection when it is obtained from the pool.

The moment when the exceptions are thrown seems quite odd to me, since my application might return closed connections to the pool (hence, faulted connections). However, I assumed that the pool would not complain about this and instead make sure that there are "Min Pool Size" open connections available.

What is the original idea behind the current implementation?
Or did I just run into a bug?

Regards,
Ruud

bozr · Post by **bozr** » Tue 06 Mar 2012 09:13

Forgot to say that I'm using version 5.70.311.

Pinturiccio · Post by **Pinturiccio** » Wed 07 Mar 2012 13:31

bozr wrote:I've got a question about the "Verify Connection" connection string property.

Did you mean ValidateConnection property?

We could not reproduce the issue with 'ValidateConnection=true'. If it is possible, create and send us a small test project with DDL/DML scripts for reproducing the issue.