I upgraded to from Windows 8.1 (64 bit) to Windows 10 (64 bit). I run an IIS-10 server, with PHP, which does an ODBC connect to a MS-Access database. I'm running the 32 bit version of Access 2016. I have installed the Access/Jet database driver.
Using the 32 bit ODBC Data Source Administrator I created a DSN named "TFD_Local" which connects to a .accdb database on the server.
The PHP script which runs on IIS execute the following
$odbc = odbc_connect('TFD_Local', '', '') or reportError("Connect error: " . odbc_errormsg() . " " . odbc_error());
and I get an:
HTTP Error 500.0 - Internal Server Error
C:\Program Files (x86)\PHP\v5.4\php-cgi.exe - The FastCGI process exited unexpectedly
I suspect that this has something to do with a 32/64 bit incompatibility as this runs OK on a 32 bit machine running the same software. This used to run on my Win 8.1 64 bit system. Note that things like phpinfo run just fine. What needs to be done to keep this from generating the 500 error?