note 26812 deleted from function.mssql-connect by danbrown
| From: | danbrown@php.net | 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).