PHP Fatal error: Class 'COM' not found

Question

I'm getting this error after upgrading PHP to v. 5.5.1:

Fatal error: Class 'COM' not found in
C:\inetpub\wwwroot\ndsystems\database_engine\mssql_engine.php on line 184

Line 184 in mssql_engine.php file:

$this->COMConnection = new COM('ADODB.Connection');    //line 184
try {
    $this->COMConnection->Open($connectionString);
    $this->RetrieveServerVersion();
} catch (com_exception $e) {
    $this->lastError = $e->getMessage();
    $result = false;
}
return $result;

Environment is Windows 2008 R2 SP1, IIS 7

Things I tried:

Added this at the end of php.ini:

[PHP_COM_DOTNET]

extension=php_com_dotnet.dll

Added extension=php_com_dotnet.dll in [PHP] section of php.ini
Rebooted IIS and also rebooted server itself.
Downgraded PHP to 5.3.27

Nothing seems to work. How do I fix this error?

Put <?php phpinfo() ?> in a test php script, open in your browser. See if the "com_dotnet" section is there and if "COM support" is "enabled." — jszobody
– jszobody, Commented Aug 14, 2013 at 19:53
Out of curiosity, why are you using ADO when you could use PHP's mssql SQL Server client library? — Dai
– Dai, Commented Aug 14, 2013 at 20:22
@Dai - I don't know much about php so I used sqlmaestro's php generator for MSSQL database. — user1060641
– user1060641, Commented Aug 14, 2013 at 20:45
@jszobody - The only reference to com_dotnet I see is in Configure Command section: cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--disable-zts" "--disable-isapi" "--disable-nsapi" "--without-mssql" "--without-pdo-mssql" "--without-pi3web" "--with-pdo-oci=C:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8=C:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8-11g=C:\php-sdk\oracle\instantclient11\sdk,shared" "--with-enchant=shared" "--enable-object-out-dir=../obj/" "--enable-com-dotnet=shared" "--with-mcrypt=static" "--disable-static-analyze — user1060641
– user1060641, Commented Aug 14, 2013 at 20:54

David Ferenczy Rogožan · Accepted Answer · 2016-04-02 20:37:53Z

3

In addition to adding

[PHP_COM_DOTNET]
extension=php_com_dotnet.dll

to your php.ini file, you have to tell PHP where to look for the extension, and to enable extensions.

To tell PHP where to look for extensions on Windows just uncomment (remove the leading ;) following line:

extension_dir = "ext"

To enable extensions set the enable flag to On:

enable_dl = On

edited Apr 2, 2016 at 20:37

David Ferenczy Rogožan

25.7k12 gold badges88 silver badges73 bronze badges

answered Jul 24, 2014 at 21:35

CallMeHarmon

313 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

nl-x Over a year ago

OP probably might NOT want to enable_dl = on , as he uses IIS, and php.ini says:

The dl() function does NOT work properly in multithreaded servers, such as IIS or Zeus, and is automatically disabled on them.

Collectives™ on Stack Overflow

PHP Fatal error: Class 'COM' not found

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related