note 81780 added to function.mssql-connect

After a couple of days (seems to be the common theme) trying to get my code to connect to our new clustered 2005 SQL server instance. I finally did it. :-) For the following setup: PHP 5.2.4 (hosted on a Windows Server 2003 box) connecting to MSSQL 2005 in a clustered environment (was already connecting to MSSQL 2000 with no problems) I was about to get the client tools installed on the server, but this would have required a trip down to the data center by our IT guys (last resort - well actually last resort was to write a data access service in Java, which was connecting fine). Anyway, after making sure all the ntwdblib.dll were of the 2000.80.194.0 version. It was still not working. The thing which made it work was simply to specify the port. yes after 2days of looking into alternatives (incidently freetds - a windows compiled version, was working very intermittently) I found all I had to do was specify the port! I guess this is because I needed to connect via TCP/IP, our network admin didn't want named pipes used (as it's non-standard). Although, named pipes were enabled anyway. Specifying the port must have made the default behavour to connect via TCP/IP. Also the port was '1433' which I assumed was default anyway, hence hadn't specified before. ---- Server IP: 87.124.64.96 Probable Submitter: 87.84.212.34 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php Edit -- https://master.php.net/note/edit/81780 Del: integrated -- https://master.php.net/note/delete/81780/integrated Del: useless -- https://master.php.net/note/delete/81780/useless Del: bad code -- https://master.php.net/note/delete/81780/bad+code Del: spam -- https://master.php.net/note/delete/81780/spam Del: non-english -- https://master.php.net/note/delete/81780/non-english Del: in docs -- https://master.php.net/note/delete/81780/in+docs Del: other reasons-- https://master.php.net/note/delete/81780 Reject -- https://master.php.net/note/reject/81780 Search -- https://master.php.net/manage/user-notes.php