MySQL with Crystal Report

Hi,

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 ?

Vaibhav
vaibhavmishra062201Asked:
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
0
 
turn123Commented:
vaibhavmishra,
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 ! --

Thanks,

turn123
EE Cleanup Volunteer
0
All Courses

From novice to tech pro — start learning today.