title: PHP - Getting MSSQL to work on Windows 10
body: <p>I am trying to connect to a MSSQL server via PHP on Windows 10. But I running into some major problems getting the following error:</p>
  
  <pre><code>Array ( [0] =&gt; Array ( [0] =&gt; IMSSP [SQLSTATE] =&gt; IMSSP [1] =&gt; -49 [code] =&gt; -49 [2] =&gt; This extension requires the Microsoft 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 [message] =&gt; This extension requires the Microsoft 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 ) [1] =&gt; Array ( [0] =&gt; IM002 [SQLSTATE] =&gt; IM002 [1] =&gt; 0 [code] =&gt; 0 [2] =&gt; [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [message] =&gt; [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ) )
  </code></pre>
  
  <p>I am asked to install Microsoft ODBC Driver 11 for SQL Server. But this driver is not compatible with Windows 10. I have installed the PHP drivers for PHP 7 and PHP 5. Neither will work without  Microsoft ODBC Driver 11 for SQL Server, but this is not compatible with Windows 10.</p>
  
  <p>Has anyone found a way round this? I have tried to download this: <a href="https://www.microsoft.com/en-US/download/details.aspx?id=36434" rel="nofollow">https://www.microsoft.com/en-US/download/details.aspx?id=36434</a></p>
  
  <p>But it is incompatible with Windows 10.</p>