Crystal Reports XI SQL/Oracle ODBC Through web using ASP

[JasGrand]

Hello, we are migrating from crystal 7 to crystal XI and it seems the reports are unable to be viewed over the web... I have downloaded the sample Active Server Pages (ASP) applications (aspxmps11.exe) from the business objects site which uses the Report Designer Component (RDC) to demonstrate functionality such as dynamically logging on to a datasource, changing selection criteria, and exporting a report at runtime. I have been able to view a report where the database is located within the same folder (access database) as the report but i am unable to view reports using ODBC connections (i have reports that link to both SQL server and Oracle databases). If anyone has any idea how I can make my reports work... please let me know. I am currently getting the following error: "Error Occurred Reading Records: Logon failed."

I don't see anywhere in the asp sample pages where the report does any connections to the database... so i'm assuming it is now stored within the report itself... Any help is appreciated...

Thanks,


Jason Grandmaison

 

[Turkbear]

Hi,
Are the DSNs used when you designed the report also configured on the Server running the web pages?






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[JasGrand]

Hello, thanks for the reply. Yes the dns is setup on the server running the webpages... do you know if the report saves the connection information? it seems that the password isn't saved anywhere in the report... perhaps that could be the problem if all the connection is now handled through the report?

Thanks again,


Jason

 

[Turkbear]

Hi,
As far as I know, usernames/passwords for the database connection (except when using published reports in Enterprise or Crystal Server) are not saved ( a security feature) unless the DSN allows for it.

If you review the samples there may be info on how to specify the database logon info in youir calling code.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[JasGrand]

nope, they don't have anything that deals with connecting to an sql/oracle database... perhaps you have come accross an example?

Thanks,


Jason Grandmaison

 

[Turkbear]

Hi,
What about the examples shown in
SimpleSetLogonInfo.zip
or
SubreportLogonExample.zip

The code:

Set mainReportTableCollection = Session("oRpt").Database.Tables


For Each mnTable in mainReportTableCollection
  With mnTable.ConnectionProperties
   .Item("user ID") = "sa"
   .Item("Password") = "sa"
   .Item("DSN") = "Pubs Sample Database"
   .Item("Database") ="pubs"
  End With
Next

seems to be a place to start..






To Paraphrase:"The Help you get is proportional to the Help you give.."