note 26812 added to function.mssql-connect
| From: | sstamps at nexvs dot net | Date: | Wed, 13 Nov 2002 19:25:02 +0000 |
| Subject: | note 26812 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-39454@lists.php.net to get a copy of this message | ||
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).
--
http://www.php.net/manual/en/function.mssql-connect.php
http://master.php.net/manage/user-notes.php?action=edit+26812
http://master.php.net/manage/user-notes.php?action=delete+26812
http://master.php.net/manage/user-notes.php?action=reject+26812