note 26812 deleted from function.mssql-connect by danbrown

From: Date: Sun, 07 Dec 2008 19:51:48 +0000
Subject: note 26812 deleted from function.mssql-connect by danbrown
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-147884@lists.php.net to get a copy of this message
Note Submitter: sstamps at nexvs dot net ---- There is a copy/paste error in the above text where it refers to the server name having to appear in the 'interfaces' file. This may have been true at one time, because somehow Sybase and MSSQL support used a similar interface, thus this was probably copy/pasted into this section from the Sybase version of this function. However, it is no longer true. I was having a problem getting MSSQL to work and was having a devil of a time finding ANY documentation on the 'interfaces' file for MSSQL (mainly because it DOES NOT EXIST); turns out it was a config problem that was easily fixed, once I stopped wasting time chasing the wild goose. SO, the short version is to IGNORE the reference to the 'interfaces' file above for MSSQL, and look elsewhere for problems getting MSSQL support working. Just a friendly bit of time-saving advice. :O) Also, the format of the 'servername' parameter is: 'hostname_or_ipaddress[,port]' . Ex: 'dbs.mydomain.com' or '10.45.234.17,2031'. Only append the port number if your MSSQL server uses a port other than the default port 1033. Using a colon instead of a comma doesn't work (at least not for me, but YMMV).

« previous php.notes (#147884) next »