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?
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()
Member
1 Points
8 Posts
How to deploy Asp.net + crystal Report in visual Studio 2008?
Jul 02, 2010 12:22 AM|bluesky_wizard|LINK
hi all i face some problem. My Crystal Report cannot work after i deploy in IIS.
it return error message:
Member
150 Points
62 Posts
Re: How to deploy Asp.net + crystal Report in visual Studio 2008?
Jul 02, 2010 02:55 AM|sandeep tada|LINK
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.
Sandeep
Please mark as answer if my post helps you....
Follow me on my Blog
Member
1 Points
8 Posts
Re: How to deploy Asp.net + crystal Report in visual Studio 2008?
Jul 06, 2010 04:15 AM|bluesky_wizard|LINK
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
Member
88 Points
54 Posts
Re: How to deploy Asp.net + crystal Report in visual Studio 2008?
Jul 06, 2010 08:55 AM|drchanix|LINK
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
Member
1 Points
8 Posts
Re: How to deploy Asp.net + crystal Report in visual Studio 2008?
Jul 07, 2010 12:52 AM|bluesky_wizard|LINK
well, i already try that and don't work.
Member
88 Points
54 Posts
Re: How to deploy Asp.net + crystal Report in visual Studio 2008?
Jul 07, 2010 04:10 AM|drchanix|LINK
Try changing the provider to SQL OLE DB.
Member
1 Points
8 Posts
Re: How to deploy Asp.net + crystal Report in visual Studio 2008?
Jul 08, 2010 03:12 AM|bluesky_wizard|LINK
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()
Member
88 Points
54 Posts
Re: How to deploy Asp.net + crystal Report in visual Studio 2008?
Jul 08, 2010 07:43 AM|drchanix|LINK
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.
None
0 Points
5 Posts
Re: How to deploy Asp.net + crystal Report in visual Studio 2008?
Oct 08, 2013 04:53 AM|ejanakieff|LINK
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