note 38936 deleted from function.mssql-pconnect by nlopess
| From: | nlopess@php.net | Date: | Tue, 13 Jan 2004 14:49:23 +0000 |
| Subject: | note 38936 deleted from function.mssql-pconnect by nlopess | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-63428@lists.php.net to get a copy of this message | ||
Note Submitter: software@yvanrodrigues.com
----
I spent hours trying to connect to a remote SQL server. I was able to connect fine using ODBC but
not using the mssql_ library.
The trick to making this work is not only installing the client component of SQL on the PHP server
but also using the Client Network Utility to (a) set the default protocol to TCP/IP (b) set up an
Alias to the remote hostname/ip address.