Link to home
Start Free TrialLog in
Avatar of cmec
cmec

asked on

MySQl ODBC Connection problem in Crystal Reports 8.5

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

Thanks....
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cmec
cmec

ASKER

Hi  Michael ,
  Your questions  Can the connection be used to display data for other applications?
                  No.
   
   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    
Glad i could help.   I don't use ODBC connectiions so really didn't know what to try or ask.  

mlmcc