• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1183
  • Last Modified:

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....
0
cmec
Asked:
cmec
  • 2
1 Solution
 
mlmccCommented:
Can the connection be used to display data for other applications?

Is the password passed correctly?

mlmcc
0
 
cmecAuthor Commented:
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    
0
 
mlmccCommented:
Glad i could help.   I don't use ODBC connectiions so really didn't know what to try or ask.  

mlmcc
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now