Mysql connection 1

[nguyenha]

I have Crystal Report XI R2 installed on Windows. I need to connect to a Mysql database located on a Linux box.
I could not find Mysql OBDC driver on the list of Database expert.
Could you advise me how to get the driver, how to install it so that I can see it on the list of Database Expert. Do I need to do anything on the Linux side.

Many thanks ahead for your help,

 

[PGFrank]

You can download the appropriate ODBC drivers from the MySQL web site. After installation, open Control Panel, Administrative Tools, Data Sources (ODBC) and create a data source to your MySQL database using the MySQL ODBC driver. Test it to make sure that it works.

Once this is done, in CR's Database Expert, click on "Create New Connection", then "ODBC (RDO)". You should see your new MySQL datasource.

Peter