I can build and use the parts of Poco I want... including Data, Data/ODBC, and Data/SQLite... but I cannot build Data/MySQL. (I also cannot build NetSSL_OpenSSL, probably for related reasons.)
In the "Building on Windows" instructions in the Getting Started page (https://pocoproject.org/docs/00200-GettingStarted.html), it is clear that the buildwin.cmd script has to be modified... but not *HOW* it has to be modifed. For example, the default installation folder for the latest release of MySQL (with server version 5.7) is under "C:\Program Files\MySQL\MySQL Server 5.7". I have tried every syntax variation I can think of, but the compiler consistently cannot find "mysql.h" despite it being in "C:\Program Files\MySQL\MySQL Server 5.7\include".
What is the correct syntax to specify "set MYSQL_DIR=?????" in buildwin.cmd? I imagine the spaces in the file path are causing an issue, but I can't work out how to escape them. I have also tried setting the INCLUDE environment variable directly, also without luck. Help?