Crystal Report,ASP and Progress Database

[lsuresh_76]

This mail is regarding some issues while using crystal report 8 in
ASP, to display reports from progress database. We used Merant ODBC
progress driver to connect the progress DB running in Unix server.The sql
query uses multiple databases and in turn it returns or looks huge no of
data to generate the output. If I am executing the query directly from
crystal report then it takes 5 to 20 mins. But output is coming at last.

The issue comes,when I am calling same report in ASP, it takes a lot (
5 mins to 10 mins) to process the data and then its showing the "Page
can not be displayed". After doing a detail study about it, we found
that when the crystal report component reading the records, internally its
stopping all the IIS services (including FTP/Admin also). The server
where it runs, is a high configured system. We have enough virtual memory
to process high end applications.

Just to inform you that the above query takes few input
parameter(selection ranges). If the ranges are less then some time it is able display
the ouput, but in case i give little big range, it stops the web
services and displays "Page can not be displayed".

We need some kind of input from you regarding where its going wrong,
as I have checked all system related possibilities which can throw this
kind of error.

 

[Marius Fiere]

It seems to me your Query is just taking to much time, if a webbrowser does not get it's answer soon enough it will display the cannot be displayed error. So either make the query perform better (indexes etc) or bracket the query into multiple smaller queries which allow you to display data.

A more difficult solultion would be to display a page saying building data and then replace that page when the query is done. I don't have the ASP knowlegde to help you on that

 

[dreyfus]

If you want not to ASP pages timeout before the query runs, you can set a new timeout value using the code below:

Server.ScriptTimeout = <value in msecs>