HELP!!! VB.Net 2 Multithreading Application

[Giacomo Arru]

Hi,

I have a BIG problem

I'm using connector/net 1.0.7 with Vb.NET 2 in a multithreading application and I need to permorm a lot of operation at the same time, the problem is that my app has to work continuosly for days and days (approx 3 months continuosly) and if I use a single connection I got many errors because MySQLDataReader locks the connection, so I have to create lots of connections, reaching in a short time the connection limit.

I have noticed that if I also correctly close and dispose the mysqlconnection (after using mysqldatareader) the server still keeps a connection open. how can i really close the connections?


Please my boss is very angry :)

thanks