Haddad Said wrote:
>
> Can you please give me a sample of code you used to achieve a
> connection? I am kind of new to both pro_mssql and Zend_db.
it's extremely simple:
$db = Zend_Db::factory($config->db->adapter,
$config->db->config->asArray());
Where config.ini contains:
[db]
db.adapter = PDO_MSSQL
db.config.host = localhost
db.config.username = u12345
db.config.password = 12345
db.config.dbname = db12345
I did a standard install of SQL Server 2005 Express, turn on the
"advanced" options during install and selected to use the "default"
instance rather than a named one. I also picked Mixed Mode
authentication in the install program. After install, I used the Surface
Area tool to enable TCPIP & Named Pipes connections.
That was about it.
Regards,
Rob...