ado not releasing connections

[yeller2]

Howdy,

When doing a lot of database reads and writes to different machines (taking data from one and putting onto another through intermediary), I eventually get an error where the port I'm connecting to is above 5000. When I do a netstat /na I can see that many connections are in TIME_WAIT state. I've tried manually closing these and there is not difference. Any ideas? The connection objects are going out of scope? Should I manually garbage collect?

thanks

 

[yeller2]

By the way, the executing environment is .net 2.0 on a win xp machine.

 

[sajidi99]

Try following two things:

1) Put everything in try{} and catch{} block, especially whereever the connection is opened, put it into try and catch block and in "finally", close the connection.

2) Use your connection like this:
using (SqlConnection Conn = new SqlConnection())
{
.... // use above connection
}

Ch Saj

http://www.shopandsmile.co.uk

 

[yeller2]

Yo dude,

I tried your suggies - they no work. I did try this though:

http://www.primaryobjects.com/CMS/Article69.aspx

and it do work!

Thanks anyhow.