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?

Answer 1

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.

Answer 2

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

Answer 3

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

Answer 4

User301128727 posted

well, i already try that and don't work.

Answer 5

User824228415 posted

Try changing the provider to SQL OLE DB.

Answer 6

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

Answer 7

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.

Answer 8

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