Error 20599 Cannot open SQL Server
I am using Crystal Reports 8.5 and calling it from VB using the Crystal reports OCX.
In Crystal Reports,If I check 'Save Data With Report',then it is working fine from VB.
But the report is not refreshed with latest data.
And If I Uncheck 'Save Data With Report' from Crystal reports and call it from VB then it is giving error like
----------------------
Run-time error '20599'
Cannot Open Sql Server
-----------------------
The report is working fine in Crystal Report Environment.
Can you please help me out, thanks.
Best Regards
Re: Error 20599 Cannot open SQL Server
You need CR to log on to the SQL server. Check out the SetLogOnInfo method.
Re: Error 20599 Cannot open SQL Server
One more thing, the reason that it appears to work when you have 'Save Data With Report'
checked is because its not trying to get the data from the db. The data is "saved with
the report" much like a snapshot.
Re: Error 20599 Cannot open SQL Server
Thanks RobDog, I was having problems with the log on server and the correct dll, I solved the problem and It works now.
Thanks again and regards. :wave:
Re: Error 20599 Cannot open SQL Server
Hi, AM Lopez...
Do you mind share out what are the correct dll?
Thanks.