industrysafe
asked on
Crystal Reports: Error occurred reading records: Server has not yet been opened
Hi,
I have created a report using Crystal report 8.5 and OLE DB database connection. When I try to view the report using Print Preview in .rpt file, I retrieve proper records. But when I go to the application (which is web based application) and try to view report in IE, I get following error message:
Error occurred reading records: Server has not yet been opened.
It looks like connection between crystal report and database is not astablished through our web based application.
I looked at knowledge base site for crystal report and tried all possible solutions.
But none of themwork.
I will appreciate if anyone can give some input.
Regards.
I have created a report using Crystal report 8.5 and OLE DB database connection. When I try to view the report using Print Preview in .rpt file, I retrieve proper records. But when I go to the application (which is web based application) and try to view report in IE, I get following error message:
Error occurred reading records: Server has not yet been opened.
It looks like connection between crystal report and database is not astablished through our web based application.
I looked at knowledge base site for crystal report and tried all possible solutions.
But none of themwork.
I will appreciate if anyone can give some input.
Regards.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I suspect a sys admin will need to change the permissions. Have them check what user is used when running from the web or an application.
mlmcc
mlmcc
ASKER
The problem is fixed. The include file in which we set username and password for crystal report database, was wrong. They changed it and now it's working.
The other issue i have is exporting crystal report to pdf using visual basic.
The program that I wrote, exports to pdf but the size of that pdf is 0kb and when i try to open it says file is currupted.
i print database, server, username, and password in vb code. everything is correct but pdf is not generated properly.
Regards.
The other issue i have is exporting crystal report to pdf using visual basic.
The program that I wrote, exports to pdf but the size of that pdf is 0kb and when i try to open it says file is currupted.
i print database, server, username, and password in vb code. everything is correct but pdf is not generated properly.
Regards.
ASKER
Thank you very much mlmcc.
The reports are working and they are also exporting to pdf.
But once in a while we receive following error message:
Crystal Reports ActiveX Designer error '80047cd5'
There are not enough Concurrent Access Licenses to log you on. This system has 5 Concurrent Access Licenses. Please try again later, or contact your system administrator to obtain more licenses. Licenses can be purchased direct from Seagate Software or through the Seagate Software Online Store.
When I restart the server, it works fine. Why could be the problem? There was one thread on this site which says to clear out some registry, but I could not understand it.
https://www.experts-exchange.com/questions/21662045/Not-enough-Concurrent-Access-Licenses-error.html
Thanks.
The reports are working and they are also exporting to pdf.
But once in a while we receive following error message:
Crystal Reports ActiveX Designer error '80047cd5'
There are not enough Concurrent Access Licenses to log you on. This system has 5 Concurrent Access Licenses. Please try again later, or contact your system administrator to obtain more licenses. Licenses can be purchased direct from Seagate Software or through the Seagate Software Online Store.
When I restart the server, it works fine. Why could be the problem? There was one thread on this site which says to clear out some registry, but I could not understand it.
https://www.experts-exchange.com/questions/21662045/Not-enough-Concurrent-Access-Licenses-error.html
Thanks.
Not sure. I know there were some problems in CR8 and maybe 8.5 with releasing the license. The application holds it open for a period of time after the report is closed.
Make sure you are releasing the license.
In VB we had to set all the Crystal objects like the report and viewer to NOTHING. Not sure how you accomplish that in a web-based application.
mlmcc
Make sure you are releasing the license.
In VB we had to set all the Crystal objects like the report and viewer to NOTHING. Not sure how you accomplish that in a web-based application.
mlmcc
Glad i could help
mlmcc
mlmcc
ASKER
Thank you very much for the reply.
I have actually tried that solution before but it didn't work. I moved p2soledb.dll from C:\windows\crystal folder to C:\windows\system32 folder but no luck.
Since the report doesn't work from our application, it may be a permission issue. But where do I set the permission? Is there any IIS setting I need to change?
Regards.