Connection Pooling

i am using vb6 and sql 2k how do i implement connection pooling....

ref this this will give u more info with example...connection pooling

any more tips...

thanks

:mad: do i need thread pooling to get solved

any one aware of it...
thanks
:D

Performance is very important.. and every one missed out it...
:o

me alone talk and wanna know about connection pooling;) :p

i have a client sever app which is used online by 40 to 50 users any time and all the time the connectionis open ... as of now my app works fine but i am not sure how long will be...

does the number of connection matter... i cannot make my app disconnect and connect its online ... does any one have a solution for this ..

give me a tip..help suggestion which can help

i have seen several threads which talk about connection should not be open for long time.... better to disconnect.. but i cannot disconnect .. if so my app will only connect and disconnect all the time....

thanks for u help:D

not again :(

look like me alone .....;) all alone.....:eek: can any one help out..