note 2108 deleted from function.mssql-connect by didou
| From: | didou@php.net | Date: | Sun, 07 Dec 2003 02:12:31 +0000 |
| Subject: | note 2108 deleted from function.mssql-connect by didou | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-61494@lists.php.net to get a copy of this message | ||
Note Submitter: angus@z-y-g-o.com
----
Remember, you must build Linux/Unix PHP with Sybase support in order to get MSSQL support.
<br>
<pre>
./configure --with-sybase=/opt/sybase-11.9.2/
</pre>
For Linux, you can get the required "Adaptive Server Enterprise" Sybase RPMs from
http://www.sybase.com/products/databaseservers/linux/<br>
You should then put any MSSQL database you want to connect to in the /opt/sybase-11.9.2/interfaces
file, in the format
<pre>
EXAMPLE_Host
query tcp ether IP_OR_FQDN PORTNUMBER
</pre>
Where PORTNUMBER is usually (but not always) 1433
<br>
In your code, refer to the EXAMPLE_Host in your connect string like this;<pre>
mssql_connect("EXAMPLE_Hostname","username","Password") or
die("Connection error");
</pre>