1 Reply Latest reply on Nov 3, 2013 8:07 PM by davidanders

    Error connecting to ODBC mySQL database

    MikeMabie

      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