MySQL 5.0 Views wont work with crystal reports

[jim_scott]

I can access my view data through the application, but when i try to create the report in crytal reports and set up the database through an odbc driver 3.51.

If i click on a normal table its fine, but with the views it says

"Error Opening File: There are no fields in the file: "[View name]".

[whiterastafari]

Hi,

I've got a similar problem but using a stored proc. (See earlier posting for more info)

After much hair-pulling and soul searching i think that their might be a compatibility problem with MySQL5, MyODBC 3.51 and Crystal.

Have you tried MyODBC 5.0 yet? If it installs and works on yr side that might take yr problem away. And if it does, please let us know what you did cause it dont wanna install here.

Thanks and good luck

[jim_scott]

Thanks

I have tried the 5.0 ODBC Connector, but unfortunatly i had no joy. Still the same error.