I’m currently trying to make reports using Crystal Report 8.5 and VB6. I’ve made report file that is connecting to SQL Server via ODBC. It’s already connected, and works when I open in CR Designer. But, when I try to open the report file using this command below, there was an error message :
run-time error :20599
Cannot open SQL Server
my coding is :
With MainForm.CREPORT
.ReportFileName = APP.Path & “\PERFORMASUMM.rpt”
.Connect = “DSN=NARAINA2007;USER ID=sa;PASSWARD=sa1;DBQ=MLBDNARAINA2007”
.Action = True
End With