note 24810 added to function.mssql-connect
| From: | guilherme_cruz at uol dot com dot br | Date: | Thu, 29 Aug 2002 02:45:22 +0000 |
| Subject: | note 24810 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-35956@lists.php.net to get a copy of this message | ||
>> 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
--
http://www.php.net/manual/en/function.mssql-connect.php
http://master.php.net/manage/user-notes.php?action=edit+24810
http://master.php.net/manage/user-notes.php?action=delete+24810
http://master.php.net/manage/user-notes.php?action=reject+24810