Click here to Skip to main content
13,147,182 members (27,579 online)
Rate this:
Please Sign up or sign in to vote.
See more: , +

I am currently using MySQL with visual studio 2010 Ultimate edition and have downloaded SAP Crystal Reports version 11 from Business Objects website. I want to set up my windows application with the crystal report viewer control to display data from one of MySQL database.

Have tried all the techniques on Google but when running the application it keeps asking for the Database logon credentials every single time. when i enter the credentials it says logon failed.

Please help.
Posted 9-Jul-12 20:55pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

How to Create a Crystal Report using C# and MySQL[^]
This will give you details of how to connect report to MySQL.

Generate a Report using Crystal Reports in Visual Studio 2010[^]
This will explains how to create crystal reports in Visual Studio 2010.

For more you can have a look on similar discussions:
How do I use SAP Crystal Reports for Visual Studio 2010 with MySQL[^]
How To Create Reports Using Crystal Reports in Visual Studio 2010[^]

Also refer Connecting to ADO.NET DataSets[^] for reference.
tusharmathankar 10-Jul-12 6:33am
Thanks Prasad for your reply, i did everything step by step as mention in the last link above Connecting to ADO.NET Datasets. however i am still getting the same database login popup saying that i need to enter my credentials for the database. Can you help?
tusharmathankar 11-Jul-12 2:54am
I have looked at various options to get rid of this Database Login popup that comes up every single time when i try and display a report. No luck so far. Can someone help?
tusharmathankar 15-Jul-12 9:21am
I finally gave up on this one, and started using Microsoft SQL Server R2, connecting to this is pretty simple without any hassles. Thanks Prasad for your links.
Member 2922478 8-Feb-13 5:44am
Hi, i am using mysql db (conn. through mysql odbc) and
my report were working fine. recently i changed mysql password and given the same in odbc DSN too. But after this i am getting login credential - crystal report asking me to type password.

Here its getting funny: If i give old password its working fine. but not with new password.
Note: i just tested to connect the ODBC from Admintools - its successfull only with new password but not with old one. -- I am totally confused here.

How crystal report is working fine with old password but not with new password ?

Any idea ? Help me to solve this issue please.
Rate this: bad
Please Sign up or sign in to vote.

Solution 3

i had this problem too..
when i try in client.
"log on failed"'
i just instal mysql odbc driver on client and it solve the problem.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.170915.1 | Last Updated 7 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100