MySQL with Crystal Report


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 ?

Who is Participating?
fotxConnect With a Mentor Commented:
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
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
All Courses

From novice to tech pro — start learning today.