Results 1 to 5 of 5

Thread: [RESOLVED] Crystal Report loading error Logon Failed.

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2010
    Posts
    965

    Resolved [RESOLVED] Crystal Report loading error Logon Failed.

    Hi. I developed the application and now when i run on any other computer except the developed one so all insertion is fine but when it comes to crystal report so it gives error that Login Failed. This is my code which produce the crystal report:

    Above this code there is a insert statement and then the code:

    Code:
    Try
                If chkReport.Checked = True Then
                    retrieveOneRecord("SaleMaster", " SaleID = " & txtSaleID.Text)
    
                    Dim objCr As New crSale
                    objCr.SetDataSource(dsSql.Tables("SaleMaster"))
                    frmSaleReport.crvSale.ReportSource = objCr
                    frmSaleReport.Show()
                End If
    If i run the same setup on developed machine so its working but not on any other computer. Please guide me for this. Why its failing.

  2. #2
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: Crystal Report loading error Logon Failed.

    You need to provide the connection information in the code using the ConnectionInfo property
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2010
    Posts
    965

    Re: Crystal Report loading error Logon Failed.

    This is my connection string in module.
    Code:
    Dim strCn As String = "Data Source = (local); Initial Catalog = AbidMIS; User ID = sa; Password = 123456;"

  4. #4
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: Crystal Report loading error Logon Failed.

    I mean pass the connection information to Crystal Reports to laod the rpt
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

  5. #5

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2010
    Posts
    965

    Re: Crystal Report loading error Logon Failed.

    My problem has been solved. I just selected the verified database option in crystal report and there I replaced the server name into (local). It was actually making the problem. When i did it, I rebuilt the setup and installed it on another PC and it worked flawlessly.

    Thank you very much Jggtz, for your time and devotion.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width