Solved

VB6 and Crystal XI and runtime error 438

Posted on 2009-05-05
11
1,688 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 101

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 101

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 101

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 101

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 101

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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

Hi All Just a quick one for everybody. I was recently looking into setting the default User Account Picture for all my vista clients within the network but on closer inspection the group policy setting only allows you to set the default pictur…
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 …
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…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

718 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