There are two things you must do: 1) *** YOU MUST EDIT ‘all.sql’ BEFORE THIS STEP *** On or around line 117 – you will need to enter your database name first!! The all.sql MySQL stored procedures supplied with the filePro® installation must be inserted into every Database with a Table that filePro® will map. ...

First thing to check is to ensure you have a valid ‘odbc.ini’ file. Depending on your system, it could be in /etc or something like /etc/unixODBC/ directories. In this example – enter ‘fPMySQL’ in the DSN field when setting up MySQL connection in define files. Here is a sample odbc.ini: [fPMySQL] Description = MySQL database ...