

The Database Pros web site has been on the internet for 20 years and gets over 35,000 hits a day by offering free FileMaker Pro tips, tricks and techniques. John Mark is best known as the author of the popular FileMaker Pro web site Database Pros. John also acted as a liaison between the technical support department and the FileMaker development team, reporting bugs, attending product meetings and acting as resource for the development team. John was the Technical Lead for FileMaker, serving as an escalation path for other technical support representatives and writing a large portion of TechInfo (now called Knowledgebase), their technical information reference. He earned his FileMaker Pro degree working on the frontlines of Claris technical support. Is it possible for me to set up MySQL 5.5 for a test? Or maybe a local Windows or Ubuntu machine? Are there any MySQL 5.John Mark Osborne has been working with FileMaker Pro for over 20 years. Is that the problem? The database version, seems to me, would be isolated from FM by the ODBC driver. Way down in the FM documentation, they say the odbc connection is for MySQL 5.5 databases, and DH MySQL is 5.1 according to the wiki. Where is this username and password set? What does FM want here? This data source still works for MS Access in Windows and Access doesn’t ask for authentification. Tried that, besides it’s part of the settings behind the ODBC data sources already. What does FM want here? It’s not the username, password on the MySQL database. I clicked on one of the MySQL connections, but FM wants a user name, password for the ODBC data source. In FM, I tried "Convert an Existing File>slide Files of type down to ODBC Source and all my Data Sources show up. I have some connections to MySQL 5.3 ANSI Driver set up in Windows 7 ODBC Data Source Administrator. I thought I’d see if FM could handle a MySQL database ODBC connection to one of my Dreamhost hosted MySQL databases. I just started out with FileMaker Pro 13 last week, and of course I wanted to drive it to the stops to see if I could break it.
