20599 Cannot open SQL server.
Hai Mr. K. Babu
i m using vb6,oracle and crystal report
this is my code:
Cr1.ReportFileName = App.Path & "\REPORTS\" & reportname
Cr1.Destination = crptToWindow
Cr1.WindowState = crptMaximized
Cr1.Connect = "DSN=nbcfdc;UID=nbcfdc;PWD=cdac;DSQ=MBit"
Cr1.DiscardSavedData = True
Cr1.Action = 1
i have tried cr1.logoninfo too but still the same error :
"20599 Cannot open SQL server."
pls help me.
thax.
Re: 20599 Cannot open SQL server.
Try :
(change constants)
Code:
Ms = "DSN=myorcl" & Chr(0) & "; " & _
"UID=myuser" & Chr(0) & "; " & _
"PWD=mypwd" & Chr(0) & "; " & _
"DSQ = " & mbit & Chr(0)
Report1.Conect Ms
JG
Re: 20599 Cannot open SQL server.
Still the same error boss.... 20599 Cannot open SQL server.
Pls help me....since last 20 days i am trying to solve this problem....
Re: 20599 Cannot open SQL server.
can u tell me ,what can be the reason behind this error. since my other report is working fine with the same code.