AnsweredAssumed Answered

Cannot connect to ODBC

Question asked by KevinJohnson on Nov 18, 2011
Latest reply on Feb 27, 2013 by MoisesAguilar

Summary

Cannot connect to ODBC

Product

FileMaker Pro

Version

11.0v3

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.

Help!

Exact text of any error message(s) that appear

The account and password you entered cannot be used to access the file.

Outcomes