For programming and general questions on Zend Framework
- Posts: 3
- Joined: Mon Jan 28, 2013 9:27 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
'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\''