General discussion

Locked

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

Vijay.

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)  

Software Forums