Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

VB6 and Crystal XI and runtime error 438

Posted on 2009-05-05
11
Medium Priority
?
1,740 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
[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

 

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

There are many reasons a PC runs slower than when it was new, ranging from malicious software intended to mess things up to simple general Windows use.  Your PC performance may slowly degrade over time without you noticing but when you buy a PC from…
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

636 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