note 28616 added to function.mssql-connect
| From: | Filipus at rack1 dot php dot net | Date: | Sat, 18 Jan 2003 01:02:56 +0000 |
| Subject: | note 28616 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-42309@lists.php.net to get a copy of this message | ||
Linux MDK 9.0, PHP 4.3.0 MSSQL 2000 on remote host
We used freetds (www.freetds.org) compiled with parameter:
./configure --prefix=/usr/local/freetds
PHP was compiled with parameter:
./configure --with-mssql=/usr/local/freetds [and some others]
We added our section in /usr/local/freetds/freetds.conf
----------------------------------
[MyServer70]
host = 172.16.20.81
port = 1433
tds version = 7.0
----------------------------------
in mssql_connect() you have to provide as a hostname the name you put between [] brackets in
freetds.conf OR specify host:port
$connection = mssql_connect("MyServer70", "d", "d");
or
$connection = mssql_connect("172.16.20.81:1433", "d", "d");
Remember to specify port!
--
http://www.php.net/manual/en/function.mssql-connect.php
http://master.php.net/manage/user-notes.php?action=edit+28616
http://master.php.net/manage/user-notes.php?action=delete+28616
http://master.php.net/manage/user-notes.php?action=reject+28616