MySQl ODBC Connection problem in Crystal Reports 8.5

Posted on 2005-03-12
Medium Priority
Last Modified: 2012-08-13
   I setup a a User DSN in ODBC for MySQL. I tried to open the DSN in Crystal Reports 8.5.  I received the following message
       "No Items Found"

 Please let me know what I am doing wrong.

Question by:cmec
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
  • 2
LVL 101

Accepted Solution

mlmcc earned 1000 total points
ID: 13526865
Can the connection be used to display data for other applications?

Is the password passed correctly?


Author Comment

ID: 13530716
Hi  Michael ,
  Your questions  Can the connection be used to display data for other applications?
   Is the password passed correctly?
          Yes since there is no password/

I have a program called MYSQL-FRONT. I was able to open the database and see the tables very easily

I checked the following:
In the ODBC Data Source Administrator
    I have a Data Source Name
    No description
    No Server
    I have a user name
    No password
    no database  

Thank you for getting me to look further
I entered the database name in odbc saved it.

I now have the MYSQL database that I want in Crystal Reports....    IT WORKS!!!!!!!!!!!

Thank you for making me think a little harder    
LVL 101

Expert Comment

ID: 13531660
Glad i could help.   I don't use ODBC connectiions so really didn't know what to try or ask.  


Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

801 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