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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 890
  • Last Modified:

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

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
JDL129
Asked:
JDL129
  • 4
  • 2
2 Solutions
 
mlmccCommented:
What version of Crystal?
By the code I am guessing it is CR9

Do the 2 reports that fail have a subreport?

mlmcc
0
 
JDL129Author Commented:
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
 
mlmccCommented:
Can you open the reports in the designer and try a VERIFY DATABASE?

mlmcc
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
JDL129Author Commented:
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
 
JDL129Author Commented:
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
 
JDL129Author Commented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now