Page 1 of 1

Connecting to Mssql DB with PHP

Posted: Mon Mar 23, 2009 4:49 am
by thewal
Hi,

I am trying to connect to mssql 2005 with SQL. I have searched the net but I am still unable to connect.

Do I need IIS running on the PC to connect?

I have used the code from the php manual but I still can't get connection. I do not get any errors showing up on the web browser either.

My DB is running on the local machine.

Thanks

Re: Connecting to Mssql DB with PHP

Posted: Mon Mar 23, 2009 5:24 am
by Christopher
Do you have the mssql driver loaded into PHP?

Re: Connecting to Mssql DB with PHP

Posted: Mon Mar 23, 2009 6:01 am
by thewal
At the end of the php ini file I have the following

[PHP_MSQL]
extension=php_msql.dll
[PHP_MSSQL]
extension=php_mssql.dll
[PHP_MYSQL]
extension=php_mysql.dll
[PHP_PDO]
extension=php_pdo.dll
[PHP_PDO_ODBC]
extension=php_pdo_odbc.dll

extension=php_sqlsrv_ts.dll