Skip to Content
Former Member
Jan 11, 2011 at 04:12 PM

Problem Connecting to MySQL Database with CR 2008


I just upgraded from CR XI to 2008. All of my old reports are fine, except for the ones that connect to a MYSQL database. If I run the report from XI, it still works fine. When I run any of them from 2008 (SP2), I get 42000 error (Database vendor code:1064). I've done a "Verify Database" command, and it updates sucessfully. But error still occurs on all MySQL reports.

I've seen several similar posts here, but they are old (from 2009), so I was hoping these issues had been resolved. But I guess not. Any suggestions?