Using Crystal Reports in Visual Basic with MySQL

Question

0.00/5 (No votes)

See more:

, +

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 20:55pm

tusharmathankar

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

sunitram rajaf · Answer 1 · 2012-11-06T21:13:00

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.

Posted 6-Nov-12 21:13pm

sunitram rajaf

Prasad_Kulkarni · Answer 2 · 2012-07-09T21:02:00

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.

Posted 9-Jul-12 21:02pm

Prasad_Kulkarni

Comments

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 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.