PHP COM extension required for database type 'ACCESS'

PHPMaker General Discussion (PHPMaker)
1

I’ve been a long time user of ASPMaker and wanted to try PHPMaker. So I installed PHP Version 7.4.6 and edited the php.ini to work with my production IIS server.

I know my php is working since the following command gave me the configuration:

<?php phpinfo(); ?>

I then installed phpmaker 2020.0.15. I also installed Composer. I know the latter is working since it executed properly from a Command Prompt.

I then tested phpmaker. After generating the files I accessed it from my browser. I got an error saying:

“PHP COM extension required for database type ‘ACCESS’ is not installed on this server. Note that Windows server is required for database type ‘ACCESS’ and as of PHP 5.3.15/5.4.5, the COM extension requires php_com_dotnet.dll to be enabled in php.ini. See http://php.net/manual/en/com.installation.php for details.”

I looked at the “ext” folder and saw a file “php_com_dotnet.dll”. So I added in the php.ini file the following:

extension=php_com_dotnet.dll

After restarting IIS I browsed the site and now the error says:

“This page isn’t working. Localhost is currently unable to handle this request.
HTTP ERROR 500”

My setup:

OS: Windows 10 Pro 64-bit
Database: MS Access Version Microsoft 365
PHP: Version 7.4.6
Composer: version 1.10.6 2020-05-06

Appreciate your assistance.

Thank you.

2

lrgalvez wrote:

I know my php is working since the following command gave me the configuration:

<?php phpinfo(); ?>



  1. If your php_com_dotnet.dll extension is successfully installed, you should see “com_dotnet” section in phpinfo.
  2. Do not use MS Access, it is much better to use MySQL, PostgreSQL or MSSQL with PHP.
  3. If you must use MS Access, is it 64bit or 32bit? You need to install the same PHP version (32 or 64 bit). And you must install the Access Runtime for that version (also same 32 or 64 bit), google “Download and install Office 365 Access Runtime”.
  4. Configure your IIS to display errors (not just 500).
  5. Make sure the IIS web server user has read/write permission to your website and the folder containing the Access database.