20599 Cannot open SQL server.

[hellovishal101]

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.

[jggtz]

Try :
(change constants)

Ms = "DSN=myorcl" & Chr(0) & "; " & _
"UID=myuser" & Chr(0) & "; " & _
"PWD=mypwd" & Chr(0) & "; " & _
"DSQ = " & mbit & Chr(0)

Report1.Conect Ms


JG

[hellovishal101]

Still the same error boss.... 20599 Cannot open SQL server.
Pls help me....since last 20 days i am trying to solve this problem....

[hellovishal101]

can u tell me ,what can be the reason behind this error. since my other report is working fine with the same code.