Solved

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

Posted on 2008-06-18
5
1,068 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

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…
The Service applet starts in Extended Mode by Default, with a taskpad on the left of the services pane. This view mode was introduced in XP. As I find it not very usefull, I like to use the Standard view as default, and without the Console tree. …
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

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