Solved

VB6 and Crystal XI and runtime error 438

Posted on 2009-05-05
11
1,619 Views
Last Modified: 2012-05-06
I have a VB6 executable with references to Crystal ActiveX Report Viewer Library 11.0 and Crystal Reports ActiveX Designer Run Time Library 11.0 and component Crystal ActiveX Report Viewer Library 11.0 running on a user's Vista machine.  I'm getting runtime error 438 object doesn't support this property or method on the OpenReport() line.  I checked the registry to make sure craxdrt.dll was pointing to the newest version.   I need to get this to work soon.  I also need to make sure that the solution does not interfere with other applications on the machine running Crystal Reports 8.5 reports.  Please help!

Set crApplication = New CRAXDRT.Application 'declared as Public CRAXDRT.Application 
 

 'Erroring on the following line

Set crReport = crApplication.OpenReport("my_crxi.rpt", 1)  'declared as Public CRAXDRT.Report

   

crReport.Database.SetDataSource rstSA, 3, 1

Open in new window

0
Comment
Question by:MariaHalt
  • 6
  • 5
11 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 24308236
I believe you need to update to SP4 if this is CR XI R1 and SP2 if it is CR XI R2.

Version
Open Crystal
Click HELP  --> ABOUT CRYSTAL
CR XI R1 is ver 11.0.xx
CR XI R2 is ver 11.5.xx

mlmcc
0
 

Author Comment

by:MariaHalt
ID: 24308310
I have 11.0.0.1282.  
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 24308542
0
 

Author Comment

by:MariaHalt
ID: 24318655
We now have 11.0.0.2495.

I created a new VB install package and then removed previous program/installed the program with new setup package on the Vista machine again.  It made no difference :(  Any other suggestions?
0
 

Author Comment

by:MariaHalt
ID: 24318678
Did I mention that it works fine on the development machine?  Can it be dependency files missing?  If so, which ones?  Or permissions?  
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 24318920
It could be.  There is a CR Runtime you can install on the clients.  I think you can download it through the Service Pack
https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/bobj_download/main.htm

I have read on the Crystal site that the recommendation for using VB6 is to use CR XI R2.  That may be simply because it is newer but there also may be fixes for your problem.  It is a free upgrade.  Download the free trial and use your Key Code from CR XI R1
http://www.sap.com/solutions/sapbusinessobjects/sme/freetrials/index.epx

mlmcc
0
 

Author Comment

by:MariaHalt
ID: 24328855
Almost there!!!  

We downloaded Crystal XI Merge Modules, put them into a .msi file and then ran the .msi on the client machine.  The VB6 program now generates the CR XI reports.  But remember part of my original question had to do with it needing to coexist with other apps that use 8.5?  Those apps are now NOT generating 8.5 reports...Error 13 Type Mismatch occuring.  

We think the problem is the craxdrt file.  The registry points to the newest version of craxdrt.  (When we register the old craxdrt the 8.5 generate but the XI do not and vice versa).  Is there some way we can get the registry to acknowledge both versions???  We think that will allow both 8.5 and XI reports to generate error free.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 24329717
I know you can if you install CR 8.5 and CR XI on the same machine.  I haven't had a reason to do that for a client.

mlmcc
0
 

Author Comment

by:MariaHalt
ID: 24329813
Lucky you!  

We tried it on a non-Vista client machine, we ran the .msi and then re-registered the 8.5 craxdrt (in the system32 folder) and then it worked!!!

So it must be some Vista thing...we'll keep trying...fortunately, we don't have to many of those machines yet!  

You set us on the right path...the points are yours...Thank you soooo much!
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 24331103
There are some issues with Vista.  CR XI requires a Service Pack to fix the issues.

mlmcc
0
 

Author Comment

by:MariaHalt
ID: 24335816
The SP we installed at your suggestion probably fixed it.  However, it turned out the problem wasn't with Vista...it was permissions on the directory where all the reports we were testing are stored (phew).  We now have programs running 8.5 and XI reports all on the same client machine with no errors!  Yipee!!!  
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

The main issue when installing Vista and XP in dual boot is when you have to reinstall any of the two when something fails, let's say a hard disk failure, a lost partition, virus, etc. What commonly happens is that you lose all your hard work config…
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…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

760 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now