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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Page Server Error

Status
Not open for further replies.

ferreseb

Programmer
Jun 17, 2002
9
US
I'm using CR 8.5 and CE 8 .The reports are accessed thru an Intranet site .

My issue is when accessing one certain report I often get the message "Cannot Open SQL server.[on Page Server ...]"

In the NT 2000 server I get a message stating
"#Version: 1.0
#Software: Crystal Web Component Server 1.0
#Date: 2002-09-24 11:16:54
#Fields: date time time-taken bytes cs-uri x-viewrpt-users
2002-09-24 11:16:54 15 2419 /repo/CHUPAMA_CHOOSE.rpt?user0=marcquery%26password0=marcquery 1
2002-09-24 11:16:55 78 20939 /repo/CHOOSE.rpt?cmd=get_pg%26viewer=actx%26vfmt=encp%26page=1%26incomplete_page=1%26incomplete_page_count=1%26PVERSION=3 2"

Any leads to solve this issue would be appreciated


Sincerely
Sebastian
Systems Admin

 
Does "OFTEN" mean that it works sometimes, but not other times???

It sounds like the datetime is improperly formatted, but it's hard to say.

Does the report run correctly within CR?

Page Server errors are common with CE8, and this may just be the usual bit of having to restart the server to get it to work.

You might try posting CE questions in the Crystal Enterprise forum.

-k kai@informeddatadecisions.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top