"Cannot open SQL server" error when trying to open report

[Guest_imported]

Hi, I am new to Crystal Enterprise. Right now, I am trying to open a Crystal Report from an html page that contains the parameters (eventually I plan on using an ASP page). I was able able to pass in values to log in to the Crystal APS and the database as well as values for the parameters but I am getting the following error: "Cannot open SQL server [On Page Server: xxx_pageserver]". When I refresh it, I get prompted for the parameters again and it works. I am using Windows NT (logged on as the administrator - I also set the username and password in the Crystal WCS as those for the NT administrator), an Oracle 8 database, and Crystal Enterprise standard edition.

I also have another question. Someone accessed from another computer the html parameter page that I made and when they submitted it to access the report, they got an http "not found" error (unlike when I access it on my computer where it opens the report viewer but gets the error I mentioned above). They were able to access the report directly from another computer by typing in the URL.

Thanks very much!
Mike

 

[Guest_imported]

I would like to add that I am using a system DSN and an Oracle driver.

 

[Infobiggot]

This is probably one of the most commonly reported errors basically it is probably worth while making some comments abou how crystal Enterprise interacts with your database for reporting purposes.

Crystal Enterprise can run reports in on demand mode as well as scheduled mode. Depending on the user's interaction with the report it will be processed with a different backend process of ce.

Scheduled mode. the Job server process which runs as a system account will create a child process which will load the crpe (print engine) this will load any of the database connectivity dll's like odbc layer and database client and talk to the database.

In on demand mode the Page Server service creates a thread that runs through the crpe it has loaded.this thread will if not already loaded load any of the database connectivity dll's that are required like the odbc layer and database client.

Now depending on what database software you are using you may need to run the page server or job server services as a user account (Informix requires this)

You will need to have the DSN configured as a system DSN (also I have noted in some cases this is case specific) Open the report in the report designer and click on Database|Set location this will show you the exact string that is stored in your report.


Make sure your password is correct when you published the report. You cqan set the properties of the report as to prompt user for database logon on the report properties. if you do not prompt or edit the database logon it will use the one you supplied with the report.

Check you actually have the oracle client proporly configured on the servers you are running CE from. I would suggest you use SQL con ( a tool provided on the CD ) or Install Crystal Reports it self on the CE server and open the report in the designer and refresh)

I hope this helps you out