I can't find the thread entitled "TP7 w/ MySQL: Full instructions by PeteW1959" anywhere on your forum.
That thread must have been lost in the conversion to the current forum software, but it wouldn't have been of much help anyway because it concerned ThumbsPlus 7, which had a very different database format.
Its author, PeteW1959, later published a MySQL database creation script for ThumbsPlus 9 which many found useful. If I'm not mistaken, ThumbsPlus 10 uses the same format. If interested (it also contains some rudimentary instructions), you can download it here:
https://www.dropbox.com/s/bb4s0v31u0xpm13/thumbs9-MySQL-by-PeteW1959.zip?dl=0I can successfully connect to my MariaDB box through a 32 bit ODBC connection so I think I'm good as long as I can get the schema working.
For MySQL, two solutions to common problems are:
- Use the Unicode driver, not the ANSI version.
- Put this in your my.ini configuration file:
sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ANSI_QUOTES"
I've never used MariaDB, so I don't know if any of this is actually relevant to your problem