none
crystal report run-time error 20599 cannot open SQL Server

    Question

  • Hi All,

    i am using vb 6.0 crystal reports 8.5 with SQL Server 2000.

     

        CrystalReport1.ReportTitle = "Payment Analysis per salesman for date range " & DT1.Value & " And " & DT2.Value & ""
        sql = "{FinalWeeklydata.Shipmentdate} IN date(" & DT1.Year & "," & DT1.Month & "," & DT1.Day & ") TO date(" & DT2.Year & "," & DT2.Month & "," & DT2.Day & ") " & sql2
        CrystalReport1.SelectionFormula = sql
        CrystalReport1.ReportFileName = reportfilepath & "\rpt\Payment_per_pound_Analysis.rpt"

    CrystalReport1.Action = 1

     

    i am getting run-time error 20599 can not open SQl Server, can any help me on this please. why i am getting this error.

     

    Thanks & Regards,

    Sharath.

     

    Monday, April 02, 2007 6:31 PM

Answers