Problem:
You're getting an error 1064 in Crystal Reports or Report Runner, unable to log into and/or connect to database, and you use MySQL.
Answer:
Make sure you do NOT have a dash in your database/table/schema. For example "jn-database" will cause the error, but "jndatabase" will not.