sql server programming: CR report - connection can't dispose -- sql server programming

Re: CR report - connection can't dispose

TheSQLGuru
4/20/2007 9:48:43 AM

sql server programming: Isn't this just connection pooling doing what it is supposed to do? See BOL
and get William Vauhn's ADO/ADO.NET Best Practices book.

--
TheSQLGuru
President
Indicium Resources, Inc.

[quoted text, click to view]

CR report - connection can't dispose

Agnes
4/20/2007 10:45:53 PM

My story is..
(1) create report by using CR.10 (connect to MSSQL)
(2) use vb.net application preview the report .

(problem) After preview the report. Connection is create , I can use SQL
servers's current activity to check it.
Even I close the reprot in my VB.net application, the connection still
exist.

So, when one user preview 10 report. (10 connections created) .
30 users preview report. (300 connection credit)

how can i correct it??