Posted by & filed under Uncategorized.

It’s this easy:

nriley@server:/var/www$ sudo apt-get install php5-odbc freetds-dev tdsodbc php5-sybase
nriley@server:/var/www$ sudo /etc/init.d/apache2 restart
nriley@server:/var/www$ php -m
[PHP Modules] 
…
mssql
mysql
mysqli
odbc
…

Configuration under Yii is simple as well. Simply add a new item under components in main.php:

'connectwiseDb' => array(
            'class'            => 'CDbConnection',
		'connectionString' => 'dblib:host=myhost.address.com;dbname=databasename',
            'username'         => 'user',
            'password'         => 'pass',
        ),

Leave a Reply

You must be logged in to post a comment.