PHP 5.5 and MSSQL driver: Installing ODBC Driver 11 in Windows Server 2012 R2
Be sure to download the 1033\x64\msodbcsql.msi (4.4 MB) installer. Even though you are using PHP x86, you need the x64 installer since the OS is x64. I had the same issue and my app now works with PHP x86 after installing the x64 installer.
Hikari
Updated on July 24, 2022Comments
-
Hikari almost 2 years
I have a Windows Server 2012 R2 with IIS 8.5, and another server with MSSQL 2012. I must install PHP in IIS and connect to MSSQL, and I don't have Internet available for Web PI.
I managed to install PHP 5.5 and I'm able to run
phpinfo()
, and I also assured thatphp.ini
is being loaded fromC:\php\php.ini
.I was also able to load sqlsrv driver, it reports in example
sqlsrv.ClientBufferMaxKBSize 10240 10240
.But when I execute a php file that connects to DB, I get a message
This extension requires the ODBC Driver 11 for SQL Server. Access the following URL to download the ODBC Driver 11 for SQL Server for x86: http://go.microsoft.com/fwlink/?LinkId=163712
I went to that site and it says
Supported operating systems for version 3.1 of the driver include Windows Server 2012 R2`.
It says
Version 3.1 requires Microsoft ODBC Driver 11 (or higher) for SQL Server
and points to
http://www.microsoft.com/en-us/download/details.aspx?id=36434`.In that page, in System Requirements, WinServer 2012 R2 is not listed. When I try to install
msodbcsql.msi
I get messageInstallation of this product failed because it is not supported on this operation system. For information on supported configurations, see the product documentation.`
Well I'm now stuck. I need PHP in WinServer 2012 R2 and IIS 8.5 connecting to MSSQL 2012. But its driver requires ODBC 11, which seems to not support latest WinServer.
Is there any hope, or will I need to wait for Microsoft to support its own OS in its own drivers?