Hi Scott,
This could be an networking issue.
Is the SQL server and the Web server on the same computer ?
Are you using tcp/ip or netbeui to communicate from web server (php) to the database
server ?
If web and database is on the same platform I would recommend using netbeui and
connect to a server named local. This gives a direct connection to the server.
If you are using two different boxes I would use tcp/ip. This uses you approx. 8 times
less bandwidth. You have to configure the client (the MSSQL Client tools on the web
server) to either use the protocol you prefer as default or by adding a client network
configuration.
mssql_connect() calls a MSSQL function to connect to the database. It first looks for
a client configuration that matches the name you are specifying as first parameter. If
that fails it tries to connect using the default protocol (doing a DNS lookup for
tcp/ip or a netbeu broadcast). These can take some time depending on network settings.
When you create a client network configuration using tcp/ip, you can connect directly
to an ip address so you wount have to do DNS lookups.
- Frank
> Hi-
>
> I have a Microsoft SQL 2000 server that I am running a simple query
> from. It is
> taking up to a minute to call. Running IIS 5.0, IE 5.5.
>
> Any thoughts? I checked the following:
>
> 1-A similar ASP script is fine.
> 2-I can ping the server
> 3-In MS Query analyzer it takes milliseconds to finish
>
> Here is the code:
>
> <select name="RESORT_ID">
> <option value="All">Search All Resorts</option>
> <?
> $connection = mssql_connect("scott", "blah", "blah!!") or die ("Can't
> connect to db server");
> $db = mssql_select_db("webdb", $connection) or die ("Can't select db!");
> $sql = "select resort_id,resort_name from resort order by resort_name";
> $sql_result = mssql_query($sql,$connection) or die ("Can't run query!");
> while ($row = mssql_fetch_array($sql_result)){
> $resort_id = $row["resort_id"];
> $resort_name = $row["resort_name"];
> echo "<option value=\"$resort_id\">$resort_name</option>";
> }
> mssql_free_result($sql_result);
> mssql_close($connection);
> ?>
> </select>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
