Please help. I am hosting on GoDaddy and know nothing about MySQL or if this will work on their server. Will this work with Access? I am trying the lite version.
STEP 4: Creating new database tables...FAILED
There was a database error:
Number: -2147217900
Source: Microsoft OLE DB Provider for ODBC Drivers
Description: [MySQL][ODBC 3.51 Driver][mysqld-4.0.27-max-log]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 1
MySQL database set-up error
MetaTraffic requires MySQL version 4.1 or later.