note 24810 deleted from function.mssql-connect by didou
| From: | didou@php.net | Date: | Sun, 04 Feb 2007 05:54:19 +0000 |
| Subject: | note 24810 deleted from function.mssql-connect by didou | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-122797@lists.php.net to get a copy of this message | ||
Note Submitter: guilherme_cruz at uol dot com dot br
----
>> Problems With Multiple Instances <<
If you are having problems to connect PHP 4.x to MSSQL 2000 on Win2K, there is a simple way to solve
it:
Open the Client Network Utility and do the following:
1. Add a new Alias choosing Named Pipes
2. Type in the Alias field (anything you want): CONN1
3. Erase Server field and type exactly: SERVER_NAME\INSTANCE_NAME
The field Pipe Name should be: \\SERVER_NAME\pipe\MSSQL$INSTANCE_NAME\sql\query
Now, in PHP, use:
mssql_connect('CONN1', 'username', 'password');
or
mssql_pconnect('CONN1', 'username', 'password');
Regards
Guilherme Cruz