I am trying to connect to an external mssql database from my local dev environment on Mac El Capitan. I notice in my php info that I do not have dblib setup in my pdo. I have mysql, odbc, sqlite. I have been looking all around to see how to get this installed and pretty much everything I have seen says to use Freetds to accomplish this. I did a brew install Freetds and it says "freetds-0.95.69 already installed". So that tells me I already have it. I am wondering if there are more steps that I am missing such as putting something in my php.ini file to get this working.
I also saw another suggestion to turn on mssql_secure_connection = On in my php.ini which I did but that did not help.
Any additional suggestions would be appreciated.
I am using a connection like this and it works when I upload it to my server which has the appropriate drivers installed.
$DBH = new PDO( "dblib:host=$host;dbname=$dbname", $user, $pass );