Hello, MSSQL Server requires the use of server aliases. Use the Cleint Network Utility to create aliases that links a name to a server and a protocol. If PHP is running on another box you can install the Client Tools from the SQL server CD. Copyiing ntwdblib.dll does not give you the complete set of client tools. - Frank > I replaced the ntwdblib.dll file with the latest downloaded online and > localhost works now. > > I found this online: > I had problems connecting to MSSQL Server on port 1433 using PHP 5 on > Windows 2003 Server. > Whenever i tried to connect to database on a remote/local server, php > tried to connect using named pipes, instead of connecting on 1433. If i > disable Named pipes on the Server, the connection fails. > As mentioned in one of the posts,from the \\Windows\\system32\\ folder, > i copied and old ntwdblib.dll (dated 2000) to the php folder, and > overwrote the newer file, dated 2005, that comes with php5 and suddenly, > everything starts working. > > > -----Original Message----- > From: Harpreet [mailto:harpreet@xxxxxxxxxxxxxxx] > Sent: Thursday, August 10, 2006 12:55 PM > To: Ariz Jacinto > Cc: php-windows@xxxxxxxxxxxxx > Subject: RE: Localhost does not work > > Yes, it does ot work for localhost or 127.0.0.1. > > Although i can view the pages using http://localhost and can also create > odbc using local. > > ________________________________ > > From: Ariz Jacinto [mailto:acjacinto@xxxxxxxxx] > Sent: Thursday, August 10, 2006 12:36 PM > To: Harpreet > Cc: php-windows@xxxxxxxxxxxxx > Subject: Re: Localhost does not work > > > does 127.0.0.1 yield the same error? > > > > > On 8/10/06, Harpreet <harpreet@xxxxxxxxxxxxxxx > wrote: > > I am using sql server 2005 and apache. And yes they r on both > the > machines. > > -----Original Message----- > From: John Meyer [mailto:john.l.meyer@xxxxxxxxx] > Sent: Thursday, August 10, 2006 12:00 PM > To: php-windows@xxxxxxxxxxxxx > Subject: RE: Localhost does not work > > Is the MySQL server located on the same machine as the Apache > machine? > > -----Original Message----- > From: Harpreet [mailto: harpreet@xxxxxxxxxxxxxxx > <mailto:harpreet@xxxxxxxxxxxxxxx> ] > Sent: Thursday, August 10, 2006 9:36 AM > To: php-windows@xxxxxxxxxxxxx > Subject: Localhost does not work > > $con = mssql_connect('localhost','username','password') > Does not work but > $con = mssql_connect($_GET["HOSTNAME"],'username','password') > works > fine. > > Please help > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
