Runtime error 20997

Posted on 2004-07-15
Medium Priority
Last Modified: 2016-09-15
I have create a VB program and using OCX to open a crystal report. 2 clients installed the program on their win2000 workstation. One of them works fine but another has error 20997.

Could you tell me what's happen? The crystal report is very simple, Just show all fields from a table on SQL Server, without OLE, Subreports.

Any idea?

Question by:cs_htm
  • 3
  • 2
LVL 101

Expert Comment

ID: 11565577

Author Comment

ID: 11573266
The crystal report come with Visual basic 5.0. I believe it is version 4.5.

Here is the code:
With CrystalReport1
.ReportFileName = <Share folder>
.Destination = crptToWindow
.Action = 1
End With

I use the same Domain user to logon 2 different workstations. But one is ok, another one is not.

I doubled check the share folder and also mapped to that. There is no improvement.

Expert Comment

ID: 11573967
OLE2 files may need to be registered. To register OLE2 files go to Start | Run, and enter:


If registration was successful the following message will appear:

Information in C:\windows\system\ole2.reg was successfully entered into the registry.

The report being previewed contained a chart, which depends upon the charting dll, "Sscsdk32.dll" and was not being distributed with the application. Once this dll was copied to the system directory of the client, the report previewed successfully.

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

LVL 101

Expert Comment

ID: 11576209
What O/S?


Author Comment

ID: 11579946
O/S is win2000 workstation sp4.

The report contains not chart and i can't find Ole.reg files in winnt directory.

LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 11589483
I suspect it is a compatability issue between VB5, CR4.5, and Win 2K.

CR4.5 has never been tested against Win 2K.  I am not sure bout VB5.


Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
In this video I will demonstrate how to set up Nine, which I now consider the best alternative email app to Touchdown.

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question