lyric0n
Technical User
- Dec 28, 2005
- 74
Hello,
I currently have an application that launches multiple threads of a function, which then go, read data from various servers, and post the data into SQL. Due to having so many threads running at once, I would like to use the same connection.
I am having a problem though when I launched my stored procedures. Due to multiple threads using the same connection, they have problems sharing this connect and end up saying that the connection is already in use.
Is there any way to have it automatically wait for the connection to be freed up before it tries to use it?
Thanks,
Chris
I currently have an application that launches multiple threads of a function, which then go, read data from various servers, and post the data into SQL. Due to having so many threads running at once, I would like to use the same connection.
I am having a problem though when I launched my stored procedures. Due to multiple threads using the same connection, they have problems sharing this connect and end up saying that the connection is already in use.
Is there any way to have it automatically wait for the connection to be freed up before it tries to use it?
Thanks,
Chris
