[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL Server 2005 Crystal Report is unable to connect: Incorrect log on parameters

Posted on 2014-01-30
6
Medium Priority
?
893 Views
Last Modified: 2014-02-02
Hey guys,

I have about 10 crystal reports that I created in VS 2008 C# version of Crystal Reports.  I have a code snippet attached that I run 5 reports by only changing the report name.  They use the same stored procedure and the same code except for the report name.  Two of the reports give the error:  Unable to connect: Incorrect log on parameters.

There must be something wrong with the reports but they work perfectly when run in the Main Report Preview.
Print.txt
0
Comment
Question by:JDL129
  • 4
  • 2
6 Comments
 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 1000 total points
ID: 39823252
What version of Crystal?
By the code I am guessing it is CR9

Do the 2 reports that fail have a subreport?

mlmcc
0
 

Author Comment

by:JDL129
ID: 39824316
mlmcc!!!  Thanks for the post!!

They were all built with whatever CR comes with VS2008 C#.
No subreport on any of the 5 reports.  I can just change the report name in the code and three will run correctly and two of them won't.  They all have the same data source which is a stored procedure in sql server 2005.

Thanks,
Jerry
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 1000 total points
ID: 39824392
Can you open the reports in the designer and try a VERIFY DATABASE?

mlmcc
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

Author Comment

by:JDL129
ID: 39824579
mlmcc!!

Yes, and it shows all the data when I run it in the designer mode.  I am creating a new stored procedure.  Maybe I just missed a field in the one I am currently using.

Thanks for your assistance!!!!!!!!!!  Keep thinking!!!!

Jerry
0
 

Author Comment

by:JDL129
ID: 39824681
mlmcc!!

I created a new stored procedure and created a new label but am still getting the same error.
I changed the name of the report to one that works and it still does.  The only thing different in the procedure is the report name.  :-(

Keep Thinking!!!

Jerry
0
 

Author Closing Comment

by:JDL129
ID: 39827813
mlmcc!!!

What I did to create the report was to replace the fields on a report that was working with the new ones I needed.  I haven't a clue why that would work and the new ones wouldn't.
Thanks for the assist!!!
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

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

Introduction This article series is supposed to shed some light on the use of IDisposable and objects that inherit from it. In essence, a more apt title for this article would be: using (IDisposable) {}. I’m just not sure how many people would ge…
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 …
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
The video provides a quick and easy steps to migrate MBOX file to well known Outlook PST and Office 365. Besides this, it also supports and migrates more than 20 email clients of MBOX which include AppleMail, Opera, Thunderbird and SeaMonkey effortl…

591 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