Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Visual-Studio MySQL , +
Hi,
 
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.
Thanks,
Tushar.
Posted 9-Jul-12 21:55pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Refer:
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.
  Permalink  
Comments
tusharmathankar at 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 at 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 at 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 at 8-Feb-13 5:44am
   
Hi, i am using mysql db (conn. through mysql odbc) and vb.net.
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
good
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.
  Permalink  

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

  Print Answers RSS
0 DamithSL 245
1 Sergey Alexandrovich Kryukov 207
2 OriginalGriff 175
3 Peter Leow 160
4 Afzaal Ahmad Zeeshan 85
0 OriginalGriff 7,380
1 DamithSL 5,359
2 Sergey Alexandrovich Kryukov 4,944
3 Maciej Los 4,906
4 Kornfeld Eliyahu Peter 4,514


Advertise | Privacy | Mobile
Web03 | 2.8.141223.1 | Last Updated 7 Nov 2012
Copyright © CodeProject, 1999-2014
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