Zf2 and SQL Server

For programming and general questions on Zend Framework
Post Reply
vinayganesh
Posts: 3
Joined: Mon Jan 28, 2013 9:27 pm

Zf2 and SQL Server

Post by vinayganesh » Fri Oct 25, 2013 9:26 pm

I am trying to access an sql server remotely from my dev machine which is a mac from my zf2 application. What is the best possible way to connect to the sql server database from a zf2 application ?

This is my db array,

Code: Select all

return array(
    'db' => array(
        'driver' => 'Pdo',
        'dsn'     => 'sqlsrv:dbname=album;hostname=192.168.0.20',
        'username'       => 'user',
        'password'       => 'pass',
        'driver_options' => array(
            PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''
        ),
    ),

Post Reply