General discussion


Error 20599 Cannot open SQL Server

By vijaysharma_3 ·
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 ,its very urgent.

With Best Regards


This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by sgt_shultz In reply to Error 20599 Cannot open S ...

just wildly guessing. configure odbc in control panel on misbehaving client?

Collapse -

by prasongso In reply to Error 20599 Cannot open S ...

When You call from VB you have to code : Example
with crystalReport1
.reportFileName = "c:\crystal1.rpt"
.discardsaveddata = true
'if you have filter for selection formula
.Selectionformula = "{Field1.Name}='" & strField &"'"
.action = 1
end with

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums