Re: PHP connecting to MSSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



In your mssql_connect statement put the port number of the server to (I.e 1433 if it is left to default)
-----------------------------------------------
Aynt perfect but cloze 2 it..
-----------------------------------------------

--------------------------------------------------
From: "Alf Stockton" <alf@xxxxxxxxxxxxxx>
Sent: Monday, March 30, 2009 3:16 PM
To: "Baboucarr Sanneh" <sanneh27@xxxxxxxxxxx>; "Sascha Meyer" <harlequin2@xxxxxx>; <php-windows@xxxxxxxxxxxxx>
Subject: Re:  PHP connecting to MSSQL

Baboucarr Sanneh wrote:
okay try including the port number for the mssql server (I.e 1433) in the connection string..that also can be the problem somethimes
 and Sasha Meyer said:
> just a guess, are you using any kind of firewall (application or port
based) > on your computer? Could you try a "telnet localhost 1433" to check if this > > works?
>
> Regarding php.ini changes: have you restarted the web server's services > > > after changing?

Yes I have restarted the needed processes.

I have now attempted testing with firewall on, with firewall turned off, with firewall on but exception made for port 1433 and a number of others but in all cases it failed with the following results.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Alf Stockton>telnet localhost 1433
Connecting To localhost...Could not open connection to the host, on port 1433: C onnect failed

C:\Documents and Settings\Alf Stockton>telnet localhost 1433
Connecting To localhost...Could not open connection to the host, on port 1433: Connect failed

C:\Documents and Settings\Alf Stockton>telnet localhost 1433
Connecting To localhost...Could not open connection to the host, on port 1433: Connect failed

C:\Documents and Settings\Alf Stockton>telnet localhost 1433
Connecting To localhost...Could not open connection to the host, on port 1433: Connect failed

C:\Documents and Settings\Alf Stockton>telnet localhost 1433
Connecting To localhost...Could not open connection to the host, on port 1433: Connect failed

BTW How can I reinstall MSSQL without loosing existing databases?

--
Regards,
Alf Stockton www.stockton.co.za

Your boss is a few sandwiches short of a picnic.


--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux