Solved

VB6 app using SQL 2000 with Crystal Reports XI works on XP but not Vista

Posted on 2008-06-18
5
1,065 Views
Last Modified: 2011-10-19
I have a VB6 app that was created to use Crystal Reports 10 and I have updated it to use Crystal Reports 11.5 SP4.   The app launches my Crystal Report correctly on an XP box, however, I get an error 18456 when I try to launch the report in Vista.  (see attached report for error, it is very simple, no other error codes, just 18456).
The machine is a laptop that was once XP then upgraded to Vista. The hard drive was not formatted at the time of upgrade.
I have SQL Server 2000 loaded on the Vista box.
I have created an MSI from the newest Crystal Reports XI Merge Modules (crxir2sp3_rdc_merge_modules.zip) and ran the MSI on the Vista machine without a problem.
I have turned off the Windows firewall in an attempt to see if that was the problem, I have turned it back on and in the Exceptions I have added SQL Service Manager, Server Network Utility and my VB6 app.
I started with a simple report which has no parameters and no restrictions, it just pulls data from one table.
I am using Crystal Reports XI Developer Edition.
My VB6 works fine and I can open it and see data.
I can use SQL 2000 Enterprise Manager to view the data in the database.
My laptop is the server and the workstation.

In case this matters: I did have an "incompatible" warning when I attempted to re-install SQL Server 2000, which I assumed was because SQL Server 2000 came about before Vista. I just continued the installation and it seemed to be fine.

My question is, "What are some common SQL related settings (or files) on the Vista box that I could be missing or have set incorrectly that I might be able to manipulate to make my Crystal Reports launch from my VB6 app.

Many Thanks,
Sk8Diva
18456.jpg
0
Comment
Question by:sk8diva
  • 3
  • 2
5 Comments
 

Author Comment

by:sk8diva
ID: 21815127
I read some posts where many people state that SQL 2000 will not work on Vista.  So, I also tried pointing my VB6 app to my XP box and have it be the server.  I can log into my VB app just fine from my vista workstation, but I still receive the same 18456 error when trying to launch the report from the Vista workstation.  The same report works fine on the XP server.
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 500 total points
ID: 21815948
Crystal requires an update to run on Vista
See this article from BO.
http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do;jsessionid=E7B7484E9C82AB765C4DCDABE9B49745?cmd=displayKC&docType=kc&externalId=8775223&sliceId=&dialogID=17736996&stateId=1%200%2017744126

Is that Release 2 of Crystal?  Release 2 is only for .Net VS 2005 compatibility.

mlmcc
0
 

Author Comment

by:sk8diva
ID: 21831670
mlmcc - Thank you for the reply.  I had already tried Crystal XI R2 SP2 and had no luck.  I currently have Crystal Reports XI SP2 SP4 loaded but still no luck.  When I did try to install SP2 as listed above, a message returned stating the ServicePack was detected on the machine and would not be installed.

I guess the question I have regarding the whole Vista compatibility thing is , "are there certain Crystal Report XI runtime files that are compatible with Vista that I need to check and make sure are in place within my Vista environment?"  If Business Objects would provide that list, I think there wouldn't be as many posts flying around regarding this.

If you have any other ideas, they would be greatly appreciated.  I am continuing to search every place I can think of to find an answer.  I truly appreciate your reply.
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 500 total points
ID: 21836452
I don't know.  The list of files required was dropped in CR10 when they moved to the merge modules.
This is  a bit old but might be applicable
http://support.businessobjects.com/library/kbase/articles/c2016112.asp

mlmcc
0
 

Accepted Solution

by:
sk8diva earned 0 total points
ID: 21847195
Thanks mlmcc, I kept going back to the integrated security document as you mentioned earlier.  I decided to turn on the integrated security on the report (since it was turned off when created in Crystal Reports 10) and when I saved the changes to my report, bam, works like a charm.  So, now I just have see what it will be like when I use an enviroment where I don't have administrator rights.
Thanks for pointing me in the right direction.
0

Featured Post

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.

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…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

707 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

11 Experts available now in Live!

Get 1:1 Help Now