Go Premium for a chance to win a PS4. Enter to Win


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

Posted on 2008-06-18
Medium Priority
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,
Question by:sk8diva
  • 3
  • 2

Author Comment

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.
LVL 101

Assisted Solution

mlmcc earned 2000 total points
ID: 21815948
Crystal requires an update to run on Vista
See this article from BO.

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


Author Comment

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.
LVL 101

Assisted Solution

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


Accepted Solution

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.

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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. …
When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
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…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

916 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