MySQL with Crystal Report

Posted on 2003-03-20
Medium Priority
Last Modified: 2006-11-17

I am using MySQL with Crystal Reports 9.0 using MySQL ODBC 3.51 driver.
I made a ODBC DSN with MySQL database.
While making a new report, it asks for database (in Database Expert window)
I selected New Connection -> ODBC -> Make New Connection
I selected proper DSN and supplied proper UserId, Password.
After this, <DSNName> came under New Connection -> ODBC
Now, on expanding this, it is showing me the databaseName, but on expanding the databaseName it doesn't show me the tableNames in that database.

But, if I use "Add Command" option under the databaseName and write query like "SELECT * FROM <tableName>", then in report design view it shows me the fieldNames of that table.

Where the problem lies, with MySQL ODBC Driver or with Crystal Reports ?

Question by:vaibhavmishra062201
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

fotx earned 400 total points
ID: 8679727
You can try with myODBC 2.5, it works with Crystal Report 9.
If you are using Crystal Reports 8.5 myODBC 3.51 has no problem
LVL 11

Expert Comment

ID: 10109840
No comment has been added lately (219 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: Award points to fotx http:#8679727

Please leave any comments here within 7 days.

-- Please DO NOT accept this comment as an answer ! --


EE Cleanup Volunteer

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
Curious about the latest ransomware attack? Check out our timeline of events surrounding the spread of this new virus along with tips on how to mitigate the damage.
The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…

752 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