HELP!! Smart Viewer Server Error

[Jman2]

When trying to open a Crystal 8 Report on an ASP page we are getting the following error:

CRAXDRT error occured in server
-2147192184: Server has not yet been opened

The report works fine when running directly through Crystal8. The report is using an Oracle 8i database connection.
We urgently need some advice on what we are missing. [sig][/sig]

 

[arh]

Two Things to try

1) Has the server that publishes the report via the web got the same DSN as the development machine used to write the report?

2) Have you passed in the correct values when opening the report, ie DSN, Database and uid,password? as below.

set crtable = session("oRpt&quot.Database.Tables.Item(1)
crtable.SetLogonInfo "DSNname", "DataBaseName", "UID","PWD"

NB The DSN must be a system DSN and the name is case Sensitive when passing into the above line.

Hope this Helps [sig][/sig]