Crystal .NET Web based report against Oracle
Is there anyone here or do you know of anyone who has successfully
implemented a web-based (ASP.NET Web Application) Crystal .NET report that
uses Oracle (either the Microsoft OLE DB Provider for Oracle or the new
managed Oracle Provider for OLE DB)?
I have successfully designed web forms without any problems that go against
Oracle using these either of these Oracle providers, but have not in
creating any Crystal .NET reports. Our web forms are/will provide parameter
settings for many web based reports as we converting an existing MS Access
front-end Oracle back-end application into a VB.NET ASP.NET application
using Oracle as the back-end. BTW we
have Oracle version 8.1.6.
I have, however got the many of the samples that CrystalDecisions provides
and that go against MS Access mdb's and other examples that go against SQL
Server 2000 (MSDE) working.
The first major problem was "Load report failed", and it was due to the fact
that the IIS web server
user ASPNET (the aspnet_wp account) was a member of the just the "user"
account for security reasons. Once I made it a member of the "administrator"
group, that error disappeared - and I know its not recommended for security
reasons, so its not a final solution.
Right now, the persistant error I get is "logon failed". Now I have also
passed the Database logon information to the report (runtime) as suggested
in the article and many other sources:
http://www.*-*-*.com/ ;but
to no avail. BTW, this runtime logon process was not necessary for either an
Access mdb nor an SQL server based .NET Crystal Report.
I'll be happy to provide any other info/code.
Thanks,
Lee
