CrystalReportviewer doesn't close the DB connection

K

Karthik

We are using the CrystalReportviewer on an ASP.NET page to render the
reports. The data binding is done by binding the ReportSource member
variable of the viewer to the InfoObject class instance, (after
casting to Report).

// infoobjects is the collection returned by querying the Business
Objects server.
crystalReportViewer.ReportSource = (Report)infoObjects[1];

According to the documentation, the viewer control itself is
responsible for opening the DB connection (based on the data sources
specified in the infoObject). Everything works fine. But the DB
connection opened by the viewer control is active even after closing
the client. (Actually the web page is accessed by a windows client via
the Internet Explorer ActiveX control). The number of connections
would increase every time we render a new report. The connections
never get released even after closing the client.

There is no way we can access the connection used by the viewer
control and close it explicitly, as the binding model doesn't support
it. What are we missing here?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,994
Messages
2,570,223
Members
46,813
Latest member
lawrwtwinkle111

Latest Threads

Top