Zend Framework and MSSQL database

Question

Hi,

Is it possible to take advantege of MSSQL in Zend Framework? I tried run my zend server with pdo_mssql, sqlserver and odbc and failed each time.

Did you menage to use Microsoft database in your project?

Kind Regards,

Answer 1

Did you try the SQL Server Driver for PHP?

Answer 2

Yes, I do use MSSQL.

Example:

private function init()
{
    $this->db = new Zend_Db_Adapter_Pdo_Mssql(array(
    'host'     => 'mssqlserver.com',
    'username' => 'dude',
    'password' => 'superman',
    'dbname'   => 'cooldata'
    ));
}