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?
thanks
# 1 Re: mysql to crystal report
You can use ODBC or OLE DB, but you need to install ODBC or OLE DB driver of MySQL.
# 3 Re: mysql to crystal report
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.
# 4 Re: mysql to crystal report
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.