Monday, March 12, 2012

mysql to crystal report

i have my db at mysql, but i need to link it to crystal report to make a report for my company.
how can i do it?
thanksYou can use ODBC or OLE DB, but you need to install ODBC or OLE DB driver of MySQL.|||how to install odbc or ole in mysql?|||how to install odbc or ole in mysql?
No, not to install ODBC in your MySQL, but in your PC.
After installation finished, then select your data source to ODBC which
using MySQL ODBC driver.|||Download MySql Connector/ODBC (http://dev.mysql.com/downloads/connector/odbc/3.51.html) and after installation.

Go to ODBC Data Source Adminiostration -> System DSN - >Add -> MySQL ODBC 3.5 Driver and set the server information.

Then you can use this connection in the Crystal Report.

No comments:

Post a Comment