VB6 and Crystal Reports – Error 20599 SQL not found

25 pts.
Tags:
Crystal Reports
Error 20599
VB 6
Visual Basic
Visual Basic 6
Sir, I have a VB 6 base software and when I click for showing Crystal base Report by package, I seem to be getting the message error 20599 SQL not found. Please help me.

Answer Wiki

Thanks. We'll let you know when a new response is added.

From what I found, the problem seems to be related to password protected tables in your database.

Here’s a possible solution.

Microsoft Visual Basic:
“Runtime error 20599 – Can’t Open SQL Server”
This issue occurs on all Active Data reports which have been created using the Active Data driver, P2smon.dll version 60046 or higher and the “Data Source” option chosen was either ADO, RDO or DAO. Reports which are created with the Data Definition file (TTX file), as the data source, do not encounter this issue.

There are two workarounds available as a solution. One is to create the report with a Data Definition file (TTX) and the other workaround is to use the Report Design Component’s (RDC) Automation Server

To create the report using a Data Definition File, see ‘Creating Field Definition Files’ in the developers help for more information on how this is done.

The next solution is to use the Report Design Component’s (RDC) Automation Server. This Automation Server does not use the Crpe32.dll, instead using it’s own print engine (Craxdrt.dll).

Good Luck!
-Flame

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following