Connecting Laravel 4 (on OSX) to MSSQL

Question

As above - trying to hook up a Laravel 4 app to an MSSQL DB. Currently I'm getting the Laravel 'Could not find driver' error page. I've found, compiled an installed an MSSQL.so extension using freeTDS and Homebrew for PHP as per this tutorial - http://lkrms.org/php-with-freetds-on-os-x-mavericks/

Running php -m from the command line lists out mssql.so in my installed extensions. I can also use freeTDS tsql command from terminal to successfully ping the target server.

Despite all this, Laravel still can't see the new driver and use it to connect, so there's obviously a piece of the puzzle I'm missing here, although a shedload of googling won't reveal it to me.

Any pointers guys?

Cheers in advance!

Answer 1

I have had issues connecting also. Here is what I did. I'm assuming that freeTDS is installed properly.

In database.php, when using a local installation make sure to use a comma instead of a colon between ip_number and port_number. If server installation use colon.

'mssql' => array(
        'driver' => 'sqlsrv',
        'host' => 'ip_number,port_number',  // Requires comma instead of colon before the port number for local installation
        'database' => 'database_name',
        'username' => 'user_name',
        'password' => 'password',
    ),

I hope this helps.