How to configure FreeTDS to work with Ubuntu 16.04 PHP (MSSQL)
<p>I have trouble to configure freetds to work with ubuntu server 16.04 which is using PHP7</p>

<p>The following code that I"m using return empty but using the same code on my another server running ubuntu server 14.04 is working fine.</p>

<pre><code> $myServer = "IPAddress";
 $myUser = "username";
 $myPass = "password";
 $myDB = "database"; 

 //connection to the database
 $dbhandle = mssql_connect($myServer, $myUser, $myPass)
     or die("Couldn't connect to SQL Server on $myServer"); 

 //select a database to work with
    mssql_select_db($myDB, $dbhandle);
</code></pre>

<p>BUT... in the terminal after installing freetds and it work great! meaning to say freetds is correctly installed but PHP is not properly configure?</p>

<pre><code>sqluser1@ubuntu1604:/etc/php/7.0/mods-available# tsql -S IPAddress -U sa
Password: 
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
1&gt; use database1
2&gt; go
1&gt; select top 2 custid from customer
2&gt; go
custid
A00001         
A00002         
(2 rows affected)
1&gt; 
</code></pre>

<p>Some article suggest me to try the following method but it doesn't work for me</p>

<p>Install (Problem: php5-sybase is not available in ubuntu 16.04)</p>

<pre><code>apt-get install libsybdb5 freetds-common php5-sybase
</code></pre>

<p>Edit php.ini (Problem: mssql.so is not exist)</p>

<pre><code>; Enable the mssql extension
extension=mssql.so 
</code></pre>

<p>Please advise and thanks</p>