Solved

VB6 and Crystal XI and runtime error 438

Posted on 2009-05-05
11
1,644 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

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
 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
So who is this article for? If you are like most of the computer users out there, you probably only realize the meaning of 'System maintenance' after something goes wrong. This article is for you if you care about keeping your system working opti…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
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…

808 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