Connection remain open

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi everybody

I have an assembly that contain Datasets, this DataSets connect to one SQL
server 2000 database and retrive information to be use for a web Service. The
problem is that when the Datasets (TableDataAdapter) connect to the database
this leave one connection open (for each user), I used the using and Dispose
keyword for try to close this connection but nothing. Somebody know how to
fix this. I am using Net 2.0

Best Regards
Victor Hugo Pozo
MCAD Net
 
Does each user have a different connection string?

In which case, that just sounds like connection pooling. I'm not sure why
everyone is always running to check what connections are open, etc, after.
And it's usually connection pooling that is keeping that connection around.
If you have a connection leak, odds are it is going to become obvious very
quickly. And if you are careful about closing your connections when you are
done, then just don't worry about it.
 
Back
Top