2. PHPRunner General questions
  3. [SOLVED]  Error connecting to MS SQL Database
This topic is locked
[SOLVED]

 Error connecting to MS SQL Database

 		8/4/2013 1:38:55 PM
PHPRunner General questions
C
 copper21 author

Hello,
Looking for some advice on how to possibly figure out why I am getting this error when opening up a test project: Fatal error: Class 'COM' not found in W:\Web Sites\InternalDefault\Test\include\dbconnection.mssql.win.php on line 28.
I have looked in the forum and can't find anything.
I am using Windows Server 2008R2 Web Edition, IIS 7.0, with SQL Server 2012 Web Edition installed on the same machine. This machine is a web server and is on a DMZ. Through PHP Runner V7.0 (Evaluation), I am able to connect to this database from my local, protected, network and create a project just fine. I go to publish the output folder on the webserver and when I go to open the project via any web browser, I get the above stated error.
I did see on a forum post that an error like this is generated when using a non-windows server, but I am using all windows stuff.
Thanks for any suggestions,
Brian
C
 		cgphp 8/5/2013

From PHP 5.4.5, COM and DOTNET is no longer built into the php core. You have to add COM support in php.ini.


Check the user comments on the PHP website http://uk.php.net/manual/en/com.installation.php
C
 		copper21 author 8/6/2013



Check the user comments on the PHP website http://uk.php.net/manual/en/com.installation.php


Cristian,
Thanks for the info; however I did add that extension and I am still getting the same error. I added it to the bottom of the php.ini file where the other extensions are and it is not commented. I should also add that I had the same issue when building a simple test project using PHP Runner 5.3.
I will keep on trying to figure this out unless you have any other suggestions.
Good to see ya, haven't seen ya here for a while.
C
 		cgphp 8/6/2013

Which PHP version are you using?
C
 		copper21 author 8/6/2013



Which PHP version are you using?


Sorry for the delay, version 5.3.27 per PHPINFO().
Thanks!
C
 		copper21 author 8/6/2013

Cristian,
You led me in the right direction and got it fixed; thanks.
I added the extension in php.ini, but the actuall .dll extension in the ext folder was missing. I updated the version of php which had the extension in it.
Thanks again!