note 53620 added to function.mssql-connect
| From: | pelanne at gmail dot com | Date: | Tue, 07 Jun 2005 14:18:45 +0000 |
| Subject: | note 53620 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-90063@lists.php.net to get a copy of this message | ||
Just in case it helps people here... We were being run ragged by extremely slow connections from
IIS6 --> SQL Server 2000. Switching from CGI to ISAPI fixed it somewhat, but the initial
connection still took along the lines of 10 seconds, and eventually the connections wouldn't
work any more.
The solution was to add the database server IP address to the HOST file on the server, pointing it
to the internal machine name. Looks like some kind of DNS lookup was the culprit.
Now connections and queries are flying, and the world is once again right.
----
Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+53620
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+53620&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+53620&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+53620&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+53620&report=yes&reason=useless
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+53620&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+53620&report=yes
Search -- http://master.php.net/manage/user-notes.php