ms-sql-s established

Hello,
I'm running a webapplication which uses msde 2000 as database server.
All webpages query the database.
If I refresh a lot of time a webpage then I get a time-out error .
With the netstat command I found a lot of ms-sql-s connections.
Is there a way to disconenct these connections?
Is there a way to repair this problem?
Thanks!
Hi
Make sure that you explicitly close the connections when you are done with
them.
You may want to try to disable connection pooling by setting it in
cliconfg.exe on the web server.
Regards
Mike
"Arjen" wrote:

> Hello,
> I'm running a webapplication which uses msde 2000 as database server.
> All webpages query the database.
> If I refresh a lot of time a webpage then I get a time-out error .
> With the netstat command I found a lot of ms-sql-s connections.
> Is there a way to disconenct these connections?
> Is there a way to repair this problem?
> Thanks!
>
>

ms-sql-s established

Hello,

I'm running a webapplication which uses msde 2000 as database server.
All webpages query the database.

If I refresh a lot of time a webpage then I get a time-out error.
With the netstat command I found a lot of ms-sql-s connections.

Is there a way to disconenct these connections?
Is there a way to repair this problem?

Thanks!I would ensure that you are ALWAYS closing connections on the page. Use try/finally blocks to ensure that open connections are always closed.

ms-sql-s established

Hello,
I'm running a webapplication which uses msde 2000 as database server.
All webpages query the database.
If I refresh a lot of time a webpage then I get a time-out error .
With the netstat command I found a lot of ms-sql-s connections.
Is there a way to disconenct these connections?
Is there a way to repair this problem?
Thanks!Hi
Make sure that you explicitly close the connections when you are done with
them.
You may want to try to disable connection pooling by setting it in
cliconfg.exe on the web server.
Regards
Mike
"Arjen" wrote:

> Hello,
> I'm running a webapplication which uses msde 2000 as database server.
> All webpages query the database.
> If I refresh a lot of time a webpage then I get a time-out error .
> With the netstat command I found a lot of ms-sql-s connections.
> Is there a way to disconenct these connections?
> Is there a way to repair this problem?
> Thanks!
>
>