Crystal and ASP

[MrMoosehead]

Does anyone out there have the secret to happy and viable reporting online with Crystal 8?
We have been beating our heads against Seagate and the servers for weeks trying to solve our problem and no luck, so here it is:

Crystal 8, IIS 4 - clean new install on NT4 SP6 dual processor machine. No MSproxy or exchange etc...

All installed on D drive. (coz it's bigger ;-) )

Taken ASP code from scrsamples and condensed it, but essentially the same.

Using reports with subreports, remote SQL server DB, connecting using DSN
Reports use stored procedures.
Reports run fine from machine itself.

Data connection fine for other ASP work.

Machine is on internal network, tried through NTws via proxy, and through the proxy machine itself.


Get an ASP0115 error and kills IIS - cannot see other ASP pages.

Sometimes get a message along the lines of:
Object session(..) has expired (or something like that)


Seagate (bless their cotton socks) have not been very useful - getting though their phone system is not easy - on hold for up to an hour. They just picked up and hung up a moment ago. Gits.

The guy actually beating his head against this has read almost every bit of literature about this type of problem with Crystal and has not managed to solve it.

Anyone? PLease? Before Ian breaks something, or goes Postal...


(Got another interesting new development with opening sample reports through browser - go back to ours, and the rptserver.asp page actually opens the previous report sample. Huh?
Open a new session and get user session has expired. )

 

[jazerr]

Well, ok then...
Try taking a look at the Database Location within Crystal itself...its in, um, Database>Set Location. If you see a bunch of crap about DATABASE.dbo.Proc(My_Proc;1), get rid of everything except the SP name. This allows Crystal to connect to any database with that SP in it, rather than being hard linked to a specific database.

Try that and let me know how it works.

 

[MrMoosehead]

Tried that already. Only proc set.
Poor old Ian, the ASP guy has sent me his cry for help to Seagate, here are some bits from it...:

---------------Ian's tales of woe--------------------
We started using Microsoft Visual InterDev 6.0… Everything looked to be OK on the webserver and the website, but after running a couple of reports things started to go wrong. It appears that the reports either run once or not at all, and that we start getting either “user session expired” or “ASP error code 0115” all the time.

Not just on the reporting website but on all ASP pages on the webserver. It is now at the stage where something terrible has happended to the webserver in that it has stopped the PDC working correctly (and Outlook / Exchange web access no longer works).

Moreover, we have tried and applied all patches, changes and tweaks found on the Seagate Crystal Decisions website and the Microsoft Knowledge Base. All to no avail.
So what we are going to do is re-install our PDC back to the basic configuration, and hopefully with your help we can have our server configured back as a web server (NT Option Pack 4.0) with Visual InterDev and Crystal Reports (web components) running on it. Our immediate requirement is to have our own reporting website for internal office use and demonstration purposes to prospective clients. This will meet our needs for the immediate short term.

NOTE: we can actually run Crystal Reports via the normal method of opening the report files on the server, and can run the reports over the web by the URL method (e.g.

http://<ourserver>/reports/myreport.rpt)

and view that way – BUT NO ASP!!!

-----------------------------
And then this:
_____________________________


OK, we reinstalled our PDC with just NT Option Pack 4.0 (for IIS), and Crystal Reports. Sucessfully ran a report with just one table only from our SQL server with charts etc no problems!!!

However, then ran a report which connected with only one table, but has subreport which runs a stored procedure. This runs fine in Crystal Reports and via our VB application but doesn’t display anything on the web compononent server. Thus, added code (from CrystalDecisions.com) to open and log on to tables in subreport. This then broke the damn server (ASP error 0115’s again! And one time stopped all the IIS sites and more often than not throws up error 0115’s on ALL asp pages – not even related to running reports e.g. default website on IIS). Net result? Reboot the PDC server!!!

HELP!

 

[sugarja]

Did you ever resolve this issue? I am having the same problem where Crystal 8 causes all ASP pages to stop working.