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....
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad i could help. I don't use ODBC connectiions so really didn't know what to try or ask.
mlmcc
mlmcc
ASKER
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