locked
How to deploy Asp.net + crystal Report in visual Studio 2008? RRS feed

  • 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