How to deploy Asp.net + crystal Report in visual Studio 2008? [Answered]RSS

• • Reply
  bluesky_wiza...

  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:

   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?
  
  

• • Reply
  sandeep tada

  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.
  

  Thanks,
  Sandeep
  
  Please mark as answer if my post helps you....
  
  
  Follow me on my Blog
• • Reply
  bluesky_wiza...

  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
  

• • Reply
  drchanix

  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

  
  

  
  

  It might be out of the box.
• • Reply
  bluesky_wiza...

  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.
  

• • Reply
  drchanix

  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.
  

  It might be out of the box.
• • Reply
  bluesky_wiza...

  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()

  
  

• • Reply
  drchanix

  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.

  It might be out of the box.
• • Reply
  ejanakieff

  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