hi all

i am using crystal report 8.5 and calling it from VB.6.0 but if i change the machine and tried to run the report through the application i am getting the following error

error number : 20599 "can not open sql server"

My source code

//connection string
strCon = "Driver=Microsoft Access Driver (*.mdb);DBQ=" & App.Path & "\Data\Database.mdb"

Set dbcon = New ADODB.Connection
dbcon.Open strCon

//


// calling report
cr1.ReportFileName = App.Path & "\Reports\New Reports\H-ListRepeatDoctors.rpt"
cr1.ReplaceSelectionFormula ("{ado.TrnsDoctor.empno}=" & Val(txtSelTe.Text))
cr1.DiscardSavedData = True
cr1.RetrieveDataFiles
cr1.WindowShowRefreshBtn = True
cr1.WindowParentHandle = MDILenbrook2002.hWnd
cr1.WindowShowRefreshBtn = True
cr1.Action = 2

so plzsuggest the solution

thanks

amol