Cannot connect to ODBC
Operating system version
Windows 7 SP1 x64
Description of the issue
Trying to connected to an ODBC data source.
Installed mysql-connector-odbc on a system running Centos 5.4 and Mysql 5.0.77. isql on localhost using odbc works fine.
Installed MySQL ODBC 5.1 Driver under Windows 7 SP1. Created a DSN. Test connection works.
Tested ODBC connection with Excel. Works.
Tested ODBC connection with Filemaker. It sees my ODBC Data Source. When I click connect it asks for a username and password (I don't think it should). When I enter the username and password to the mysql database I get "The account and password you entered cannot be used to access the file." Please try again.
Exact text of any error message(s) that appear
The account and password you entered cannot be used to access the file.