MultiThreaded App and Connection to SQL server issues 2

[NoCoolHandle]

I am hoping someone can help me here.

I am attempting to write an applicaion that can connect to 150 + sql box's in a multi threaded manor.

i.e. I don't want to wait for the first command to complete before opening a new connection and starting the process there.

When I start a new thread (second and beyond) that should connect to a different server, I get an error indicating that the connection pool is full and another connection can't be made.

The strage thing here seems to be that each connection is to a different server. My understanding is that connection pooling only kicks in for connection strings that are indentical. Each string here is different.

Is it possible that ado is single threaded and once a connection is open and executing a new connecton can't be created?

The connection in question lives in a seperate class that is instanciated for each server.. I.e. dim c as new controller

then a thread is created and points to a method of the class which is then exectued via the start method of the thread.

This one is kicking my B(^%*%

TIA

Rob

 

[chrissie1]

AJAX is a Dutch football team (soccer for you guys on the wrong side of the ocean).

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[earthandfire]

Did you just swear chrissie?