php-windows Digest 31 Mar 2009 08:07:28 -0000 Issue 3593
Topics (messages 29230 through 29232):
Re: PHP connecting to MSSQL
29230 by: Alf Stockton
29231 by: Sascha Meyer
29232 by: Baboucarr Sanneh
Administrivia:
To subscribe to the digest, e-mail:
php-windows-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-windows-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-wind...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
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.
--- End Message ---
--- Begin Message ---
Hi Alf,
your local SQL Server is probably listening on another port ... perhaps you
could try the following in a DOS prompt:
netstat
and
netstat -n
The first should give you all open local ports with descriptions to the port if
a default port was used. The second will give you all open ports with port
numbers instead of protocol names. This could help you check if your server is
listening on another port.
Alf wrote:
> BTW How can I reinstall MSSQL without loosing existing databases?
You can export your local databases on various ways before reinstalling, i.e.:
a) use the osql (located in MSDE's binn folder) command tool from MSDE (or
MSSQL Server Editions)
http://www.rs-freeware.org/osql/#dumping
b) Copy your data Dir (could be "C:\Program Files\Microsoft SQL
Server\MSSQL\Data") and attach the database to a full MS SQL Server
c) Install MS SQL Server Client Connectivity and connect to your database
Good luck!
Regards, Sascha
--
Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen:
http://www.gmx.net/de/go/multimessenger01
--- End Message ---
--- Begin Message ---
Alf you can also check the Server network utility from the From the sql
server installed and check the properties of the TCP/IP to see the port
number for the mssql server.
Well the default is 1433 ...
-----------------------------------------------
Aynt perfect but cloze 2 it..
-----------------------------------------------
--------------------------------------------------
From: "Alf Stockton" <a...@stockton.co.za>
Sent: Monday, March 30, 2009 3:16 PM
To: "Baboucarr Sanneh" <sanne...@hotmail.com>; "Sascha Meyer"
<harlequ...@gmx.de>; <php-wind...@lists.php.net>
Subject: Re: [PHP-WIN] 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.
--- End Message ---
