Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot Open SQL Server & Print Engine Errors

Status
Not open for further replies.

InShadows

IS-IT--Management
Jul 7, 2000
36
US
When starting the reports today, I get the following errors.
Cannot Open Sql Server
Print Engine Error

After I receive the first error I click on Ok and then go to the location bar and Enter. Then I get the second error. Then I go to the location bar and Enter. The report comes up fine.

Background: The user is being sent from an ASP application to the Crystal Report. Once the user has chosen their parameters they are redirected to a new popup window which is then redirected to the correct crystal report. We did this for security reasons so the usernames and passwords are not visible.

I tried this via no redirection and one single popup and received the same errors. The SQL connection is correct because I would keep on receiving the error if it wasn't.

Also which may or may not pertain to the situation. Whenever I receive the first error (Cannot Open SQL Server) a file is written to my Desktop entitled logger_asserts.log and the line that is written is something similar to the following:

12:43:18 (1672, 1596), (1, 1, 33009), Info: Could not find resource DLL 'stringres'. Some strings may not appear. Location: M:\silib\slib\src\sresmanager.cpp,455 expr: retval

Thanks in advance.
 
I have recieved the same error messages when trying to run a simple report. (CANNOT OPEN SQL Server).

Can anyone help

....thanks
 
I was able to correct the error. My method might not be the proper solution for you but it is a solution.

To rid yourself of the logger_asserts.log file on the desktop of the clients download the latest actxview.zip file from crystal.

ftp://ftp.crystaldecisions.com/outgoing/ehf/actxview.zip

And I corrected the Cannot Open SQL Server by not saving the data in the report before publishing it to the server.

I hope this helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top