Hi,
I have been trying to load a Crystal Report newly created via VS.Net 2003.
I am using a simply ASP form with only the Crystal Report Viewer. The
sample report results display in the WebForm1.aspx, when I have set the
databinding Report Source property set at design time.
I get the following error message when I try to run the report.
CrystalDecisions.CrystalReports.Engine.LogOnExcept ion: Logon failed.
In searching Google, in several instances it advised to set the properties
via code instead of at design. This is the suggested code that I placed in
the PageLoad. I am using a dataset created via a SQLAdapter dragged from
the Toolbox. Within Crystal, I tried using the Project dataset and the
Connection Dataset. I even tried a new ODBC connection to the server.
Dim oRpt As CrystalReport3
oRpt = New CrystalReport3
'oRpt.SetDatabaseLogon("user", "password")
'oRpt.SetDatabaseLogon("user", "password","server","database")
CrystalReportViewer1.ReportSource = oRpt
Me.SqlDataAdapter1.Fill(Me.DataSet11)
CrystalReportViewer1.DataBind()
Since most of the discussion on Google centered around the logon info, I
have tried with and without setting login and using different syntax. I
still end up with the same error message.
Once again the Google discussion says that Crystal does not use Windows
Authentication that allows permission to ASPNET users. I am not overjoyed
about have my password in the code, but right now I would be happy getting
any Crystal report executing.
Are there any suggestions or corrections. One comment said that the user
and password were the SQL user and password found in the Config file. But
since my app is set up to use ASPNET as permissible users, there is nothing
in the Config file.
By the way, how do I verify what my SQL UserID and Password are? I have
just set up this environment recently, it is possible that I am using the
wrong combination.
thanks,
hugh
