note 28603 rejected from function.mssql-field-name by cortesi
| From: | cortesi@php.net | Date: | Sat, 18 Jan 2003 01:05:03 +0000 |
| Subject: | note 28603 rejected from function.mssql-field-name by cortesi | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-42310@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!