Hi All,
I am in the middle of a migration project, where I have to migrate all my Linux based MySQL databases to a Windows based MS SQL 2005 Express.
I have one IIS 6.0 webserver and one SQL 2005 Express server (2 boxes). I have verified that I can create an ODBC connection to the SQL server (to verify the SQL server configuration).
I run into trouble as soon as I try to connect to the MS SQL server via PHP.
Source code:
<?php
$connection = mssql_connect("TW-SQL01","test","test");
echo "connected";
?>
The last line is just to verify that my script is not stuck somewhere. Unfortunately the script is stuck which the first line.
I have the mssql extension enabled (verified in phpinfo()).
Any help will be appriciated.