note 29026 rejected from function.mssql-connect by didou
| From: | didou@php.net | Date: | Fri, 30 May 2003 12:12:57 +0000 |
| Subject: | note 29026 rejected from function.mssql-connect by didou | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-49421@lists.php.net to get a copy of this message | ||
Note Submitter: tsangel@hamosu.yonsei.ac.kr
----
Using MULTIPLE INSTANCE of MSSQL 2000
1. Windows environment
it's simple.
You can connect the database as many other people do.
$cnx = mssql_connect("hostname\\INSTANCE_NAME", "id", "pwd");
2. Linux or FreeBSD environment
it's not simple...
You cannot connect the database as described above.
FreeTDS does not understand the form like "hostname\\instancename", so above code will
make error.
Because multiple instance use dynamic port other than default port 1433, you have to specify the
port number which is assigned for the instance.
$cnx = mssql_connect("hostname:portno", "id", "pwd");
( portno ; port number which is assigned for the instance in MSSQL 2k. )
But, problems occur in finding the right port number for instance because of dynamic assignment of
port number. ... and... i don't know how can I find the number using protocol over 139/445. --;
Is there anybody help me?