RE: [PHP-WIN] Help, connection object in php
| From: | Erik H. Mathy | Date: | Mon, 29 Oct 2001 18:21:40 +0000 |
| Subject: | RE: [PHP-WIN] Help, connection object in php | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-10085@lists.php.net to get a copy of this message | ||
> Is is possible to set the connection object to point to a database on
> another server? I'm using SQLserver and IIS and would like to point the
> connection object to the SQL server. SQL server is on one
> computer and IIS is on another.
Yep. That's part of the mssql_connect(); syntax.
$conn = mssql_connect("ComputerName", "Account", "Password");
The name is generally the name of your other box (or IP address, if it's
static), account is the sql account you're using to connect and password,
is, um, the password.
More info:
http://www.php.net/manual/en/function.mssql-connect.php
Enjoy,
- Erik