Frank-
Thanks for the thoughts. The db Server is not on the same machine as the
web server.
They are connecting via tcp/ip. I used the IP address to rule out DNS
trouble.
One interesting note. For fun I downloaded Apache for Win32, installed it
and the php
modules in it. Used the same exact page to connect to a SQL 2000 db
server--in other
words I did not change any of the source code and it connects and returns
instantly! We
are talking about a 20 to 1 difference in speed from IIS 5.
At 11:10 AM 6/21/2001 -0700, Frank M. Kromann wrote:
>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
--
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]
