在Windows 10上通过ODBC连接到Access数据库时出现IIS 500错误

Question

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?

Answer 1

To answer my own question:

I deleted the DSN which had been created by going through the Administrative Tools/ODBC Data Sources (32 Bit) and then ran C:\Windows\SysWOW64\odbcad32.exe and recreated it. I don't know what the difference is, but this worked.