Crystal Reports and MySQL 1

[infomania]

Is there some trick to getting the MySQL database tables visible in Crystal Reports?

I am using the MySQL Driver 3.5 (on WinXP Pro) , the current version on MySQL and CR v9. I can connect to the database (I see it in CR) but when I click on the expand +, the tables are not there. I can, however, hand jam a SQL string into the Command box and it runs fine (so... I know I'm connected and can execute SQL commands).

Any help will be appreciated.

THank you.

 

[HermanvLimbeek]

It's a bug in Crystal Reports. There is a hotfix available at ftp://ftp.crystaldecisions.com/outgoing/ehf/cr90dbexwin_en.zip.

Good luck

 

[infomania]

Thank you. That did the trick. It requires a reboot after installing the patch. All tables are now visible.

infomania