Recently my boss desided to migrate from MS sql to MySQL.  I have the great job of fixing all our reports into the new setup.

I made all the db's and stuff needed on the mysql server itself and it seems to be working great there.

 

Now when i make a new report select the view i need i get the following error:

Error in Databaseconnector 42000 MySQL ODBC 5.1 driver

You have a error in your  SQL syntax; check the manual that corresponds to your mysql server version for the right syntax to use near 'multi filiaal where 0=1' at line 1  db error :1064

 

The view itself works perfect when i run him with navicat (view code here ).

Anybody has a idee what could couse this error ? if it's mysql related or more error from CR itself.

 

All help appreciated

 

Adam

 

I got this working for 1 view but it keeps crashing on my other views (different db's on same server)

 

Error that i get :

The exception unknow software exception (0xc0000409) occurred in the application at location 0x07204872. 

Click ok to terminate / cancel to debug

 

both close down the program..

 

Any idees ?