AnsweredAssumed Answered

Error connecting to ODBC mySQL database

Question asked by MikeMabie on Nov 3, 2013
Latest reply on Nov 3, 2013 by davidanders

Title

Error connecting to ODBC mySQL database

Post

     Hi All,

     I'm trying to set up a system where I use FMP to connect to my web stores live mySQL database (remote server).  I want to add inventory in the shop with a scanner and be able to run reports easier.

     I have had issues at each step but have been able to get it sorted.  I have my ip added for full privileges on the mySQL remote server.  I have the ODBC drivers installed.  I want to link to a table called "Products" from the remote database.  When I enter manage-database-relationships and click add table I see my table and select it.  Next I see my tables in the remote data base.  When I select "products" or any table I get:

     "This action cannot be performed because the required table is missing."

     Can anyone help me with this?  I'm new to file maker pro but have some database experience.

      

     Thanks,

      

     Mike

Outcomes