Re: PHP Runs But Does NOT Connect to MSSQL Server

On Fri, 13 Jun 2008 10:32:22 -0400 "Wei, Alice J." <ajwei@indiana.edu> wrote: > Hi, Greg: > > I have just run the command > > [root@localhost php-5.2.6]# php -m | grep mssql > mssql > > It appears that my RPM is fully installed. I could ping to the > machine, but I could not connect to it. I have set the TCP to 1433, > and UDP to 1434. Therefore, even though my syntax > > $dbhandle= mssql_connect($myServer, $myUser, $myPass) > > appears to be accurate with the proper password, ip, and username > defined prior to this, I only get "PHP Warning: mssql_connect(): > Unable to connect to server: 192.168.10.128 > in /usr/local/apache/htdocs/test.php on line 22" Could there be > something that I have missed? > Alice Perhaps. Check the documentation for myssql_connect and be sure that you're not supposed to also provide a port number (in your case 1433) along with the hostname argument. IIRC you can tag it after the hostname/ip using a colon (e.g. myhostname:1433). Other than that it seems more like a network connectivity issue. This is OT for this list but if it was my problem I'd ensure there aren't any packet filters between my web server and db hosts. Since MSSql has to run on windows I'd start there and ensure inbound connects to TCP 1433 are allowed. You're using private address space (192.168.x.x). Are BOTH servers on the same subnet? GM -- Greg Maruszeczka http://websagesolutions.com skype: websage.ca googletalk: gmarus