Connection Pooling is not working

  • Thread starter Thread starter Marco Roberto
  • Start date Start date
M

Marco Roberto

Hi,

I have Windows Form application that access Sql Server 2000.
I copied this application inside a network path (Ex: h:\application).
The connection string is inside the application (hard-coded). If five
users access the application and I run sp_who in Query Analyzer it
displays five connections. The question is: Do I need to build an Enterprise
Serviced component and set the object pooling property as true to make
it work?
I say that because when I have one thread and I create two or more
connections inside this thread I know that the connection pooling will
work.

Regards,

Marco
 
Take a minute to read my article on Connection Pooling.
http://www.betav.com/sql_server_magazine.htm
In a Windows form app, each process (each application) gets its own pool
that lives on the client system. Until you move the data access
functionality to the middle tier or create an IIS-based application, the
connection pool won't help much outside the scope of each instance of your
application. What you're seeing is "by design".

hth

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Tanks Bill, I understood what you said. Unfortunately I
could not access your article because I would have to
subscribe the magazine, but I understood your point.

Tks

Marco
 
Back
Top