Zend Framework and SQL Server

Question

I'm trying to use Zend Framework with SQL server 2005 express (through Pdo_Mssql with wamp installation) but seem that pdo can't connect to SQL. This is my code:

require '../application/bootstrap.php'; 

try {
    $db = Zend_Db::factory('Pdo_Mssql', array(
    'host'     => 'localhost',
    'username' => 'sa',
    'password' => 'verystrongpass',
    'dbname'   => 'msdb'
));
    $db->getConnection();
} catch (Zend_Db_Adapter_Exception $e) {
    $e->getMessage();
} catch (Zend_Exception $e) {
   $e->getMessage();
}


$sql = 'SELECT * FROM table';

$result = $db->fetchAll($sql);

echo "----------------" . var_dump($result);

and the error result is always:

Fatal error: Uncaught exception 'Zend_Db_Adapter_Exception' with message 'SQLSTATE[01002] Unable to connect: SQL Server is unavailable or does not exist. (severity 9)' in C:\wamp\bin\php\php5.2.5\lib\Zend\Db\Adapter\Pdo\Abstract.php:130 Stack trace: #0 C:\wamp\bin\php\php5.2.5\lib\Zend\Db\Adapter\Pdo\Mssql.php(135): Zend_Db_Adapter_Pdo_Abstract->_connect()

1 C:\wamp\bin\php\php5.2.5\lib\Zend\Db\Adapter\Abstract.php(389):Zend_Db_Adapter_Pdo_Mssql->_connect()

2 C:\wamp\bin\php\php5.2.5\lib\Zend\Db\Adapter\Pdo\Abstract.php(205):Zend_Db_Adapter_Abstract->query('SELECT * FROM t...', Array)

3 C:\wamp\bin\php\php5.2.5\lib\Zend\Db\Adapter\Abstract.php(616): Zend_Db_Adapter_Pdo_Abstract->query('SELECT * FROM t...', Array)

4 C:\Documents and Settings\Luca\Documenti\Workspace\web\db\public\index.php(27): Zend_Db_Adapter_Abstract->fetchAll('SELECT * FROM t...') #5 {main} thrown in C:\wamp\bin\php\php5.2.5\lib\Zend\Db\Adapter\Pdo\Abstract.php on line 130

So anyone have some experience with ZF + SQL server, SQL server need some special configuration? In istallation time i've only specify to use the default istance and to use mixed authentication. Moreover I can successful connect with db through Microsoft SQL server management studio express.

Robert MacLean · Accepted Answer · 2009-03-11 11:56:51Z

1

All SQL Server Express installations on a named instance of SQLEXPRESS rather than a default instance - see this.

So your host should look like

'host'     => 'localhost\SQLEXPRESS'

answered Mar 11, 2009 at 11:56

Robert MacLean

39.3k26 gold badges102 silver badges154 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

score 0 · Accepted Answer · 2009-10-07 18:42:09Z

0

Can you pls check in you PHP.ini file, that you enabled the Pdo_Mssq.dll

If not remove the ";" in front of the Pdo_Mssql.dll

Dan

edited Oct 7, 2009 at 18:42

answered Oct 7, 2009 at 18:34

user185843

1 Comment

Marc Gravell Over a year ago

No spam footers please; they will be removed.

Hiranya Sarma · Accepted Answer · 2017-12-29 09:50:00Z

0

I think your

'host' => 'localhost\SQLEXPRESS' configuration

should be like :

'host' => 'computer_name\SQLEXPRESS'

edited Dec 29, 2017 at 9:50

Hiranya Sarma

1,4764 gold badges15 silver badges27 bronze badges

answered Jan 21, 2013 at 17:48

John Mex

11 bronze badge

Collectives™ on Stack Overflow

Zend Framework and SQL Server

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related