Answered by:
How to deploy Asp.net + crystal Report in visual Studio 2008?

Question
-
User301128727 posted
hi all i face some problem. My Crystal Report cannot work after i deploy in IIS.
it return error message:
Logon failed.
Details: ADO Error Code: 0x
Source: Microsoft OLE DB Provider for SQL Server
Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
SQL State: 08001
Native Error:
Error in File C:\DOCUME~1\PCHO02~1\ASPNET\LOCALS~1\Temp\CRAgingAR {601E0E56-4DE4-4DC1-A358-896394B4181C}.rpt:
Unable to connect: incorrect log on parameters.
i think it because i don't know how to deploy .
can some one share how to do it?Friday, July 2, 2010 12:22 AM
Answers
-
User824228415 posted
Is ConnectionInfo a class where you created your connection to the sql database?
Can we have a look at your web/app.config file?
If you have problems for connection strings, try this site, http://www.connectionstrings.com.
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Thursday, July 8, 2010 7:43 AM
All replies
-
User-284145432 posted
To runcrystal report on web server you need to install crystal report runtime on your server.
you can download it from buisness object's official url.
Friday, July 2, 2010 2:55 AM -
User301128727 posted
does it need some configure IIS for crystal report?
can you give me link for download it? because i always failed when searching this crystal report runtime for my case.
i am develop using visual studio 2008 standar edition
Tuesday, July 6, 2010 4:15 AM -
User824228415 posted
Try this link. It might help you.
http://weblogs.asp.net/guybarrette/archive/2008/04/24/how-to-deploy-the-crystal-reports-2008-basic-runtime.aspx
Tuesday, July 6, 2010 8:55 AM -
User301128727 posted
well, i already try that and don't work.
Wednesday, July 7, 2010 12:52 AM -
User824228415 posted
Try changing the provider to SQL OLE DB.
Wednesday, July 7, 2010 4:10 AM -
User301128727 posted
how to change provider to sql OLEDB?
actually i set the connection in code like this:
Dim ConnInfo As New ConnectionInfo
With ConnInfo
.ServerName = ConfigurationManager.AppSettings("DatabaseServer").ToString
.DatabaseName = ConfigurationManager.AppSettings("DatabaseName").ToString
.UserID = ConfigurationManager.AppSettings("DatabaseUserName").ToString
.Password = ConfigurationManager.AppSettings("DatabasePassword").ToString
End With
Me.CRVAgingAr.ReportSource = Server.MapPath("~\Report\CRAgingAR.rpt")
Dim ParamField As ParameterFields = Me.CRVAgingAr.ParameterFieldInfo
Dim ParamKdKonsumen As New ParameterField
ParamKdKonsumen.Name = "@cus"
Dim ParamKdKonsumen_value As New ParameterDiscreteValue
ParamKdKonsumen_value.Value = Session("KdKonsumen").ToString
ParamKdKonsumen.CurrentValues.Add(ParamKdKonsumen_value)
ParamField.Add(ParamKdKonsumen)
For Each cnInfo As TableLogOnInfo In Me.CRVAgingAr.LogOnInfo
cnInfo.ConnectionInfo = ConnInfo
Next
Me.CRVAgingAr.RefreshReport()
Thursday, July 8, 2010 3:12 AM -
User824228415 posted
Is ConnectionInfo a class where you created your connection to the sql database?
Can we have a look at your web/app.config file?
If you have problems for connection strings, try this site, http://www.connectionstrings.com.
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Thursday, July 8, 2010 7:43 AM -
User-891884238 posted
I have the same problem.
Solved you it?
I have installed the Crystal Report for Visual Studio 2008 runtime into the web server, and I get the same error.
But when I execute the asp.net application in Visual Studio 2008 environment it works fine.
Thanks,
Eva Janakieff
Tuesday, October 8, 2013 4:53 AM