• Article for your preferred language does not exist. Below is international version of the article.

Article ID: 117880, created on Oct 11, 2013, last review on May 10, 2014

  • Applies to:
  • Operations Automation

Symptoms

PHP 5.3 for IIS is installed on a POA-managed Windows shared hosting server in accordance with the Windows Shared Hosting Deployment Guide.

The phpinfo() shows that PHP is compiled without the MS SQL support:

--without-mssql --without-pdo-mssql

As Provider I want to enable the MS SQL support in PHP installed on POA-managed Windows server.

Resolution

PHP on POA-managed Windows servers is installed through the POA package; actually, in backend, the POA package just unpacks and installs the stock PHP, Parallels does not modify or patch PHP installed on Windows shared hosting servers.

To enable support of MS SQL or any other missing module, Provider should download appropriate extension, place it in the PHP extensions folder (check the value of the 'extension_dir' parameter in output of the phpinfo() to find the exact location, usually it is 'C:\PHP5\ext') on the Windows server and enable it by adding the line like this in the 'php.ini' file (the exact location of the 'php.ini' file can be found in the output of the phpinfo(), usually it is 'C:\PHP5\php.ini').

As stated on the official PHP website php.net, the 'php_mssql' module is no longer shipped starting from PHP 5.3.

Provider may either find compatible 'php_mssql' module provided by 3rd-party company or try to use the 'sqlsrv' module from Microsoft.

Search Words

mssql module

MS SQL support in PHP

php_mssql.dll

caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF