Connection Pooling

[khalik]

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

[khalik]

do i need thread pooling to get solved

any one aware of it...
thanks

[khalik]

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

[khalik]

me alone talk and wanna know about connection pooling

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

[khalik]

not again

look like me alone ..... all alone..... can any one help out..