PHP with MS SQL on Windows Box

[Kieran Benton]

Hi everyone,
Sorry to bother you, have just spent the last few hours trying to solve
this. Have uncommented the line in php.ini, ensured the client tools are
installed. However when I try and view a PHP page now, the browser just
hangs indefinitely. If i take away the line in php.ini everything
returns to normal. Have heard I have to recompile with the freetds
library but am i not right in saying that is for unix/linux?

Thanks for ur help,
Kieran

[Jochen Daum]

Hi Kieran!

On Mon, 16 Feb 2004 19:50:00 +0000, Kieran Benton
<ki**********@fastmail.fm> wrote:

Hi everyone,
Sorry to bother you, have just spent the last few hours trying to solve
this. Have uncommented the line in php.ini, ensured the client tools are
installed. However when I try and view a PHP page now, the browser just
hangs indefinitely. If i take away the line in php.ini everything
returns to normal. Have heard I have to recompile with the freetds
library but am i not right in saying that is for unix/linux?

I think you are right. Do you use a named based resolution to get to
your SQL server or an IP address? Can you do

ping nameofsqlserver

telnet nameofsqlserver 1433
telnet ipaddressofsql 1433

Is SQL server listening on named pipes or tcp. Must be tcp afaik.

HTH, Jochen
--
Jochen Daum - Cabletalk Group Ltd.
PHP DB Edit Toolkit -- PHP scripts for building
database editing interfaces.
http://sourceforge.net/projects/phpdbedittk/

[Kieran Benton]

Jochen,
Yes I can reach the database in this manner, TCP/IP is turned on and it
is used elsewhere on the network for ASP.NET and bespoke apps. Any more
suggestions?

Many thanks,
Kieran

Jochen Daum wrote:

Hi Kieran!

On Mon, 16 Feb 2004 19:50:00 +0000, Kieran Benton
<ki**********@fastmail.fm> wrote:

Hi everyone,
Sorry to bother you, have just spent the last few hours trying to solve
this. Have uncommented the line in php.ini, ensured the client tools are
installed. However when I try and view a PHP page now, the browser just
hangs indefinitely. If i take away the line in php.ini everything
returns to normal. Have heard I have to recompile with the freetds
library but am i not right in saying that is for unix/linux?

I think you are right. Do you use a named based resolution to get to
your SQL server or an IP address? Can you do

ping nameofsqlserver

telnet nameofsqlserver 1433
telnet ipaddressofsql 1433

Is SQL server listening on named pipes or tcp. Must be tcp afaik.

HTH, Jochen

[Jochen Daum]

Hi!

Jochen,
Yes I can reach the database in this manner, TCP/IP is turned on and it
is used elsewhere on the network for ASP.NET and bespoke apps. Any more
suggestions?

Maybe check for other php.ini's, if yours is used at all or maybe the
default settings are on and yoru webserver has been restarted.

HT, Jochen

Many thanks,
Kieran

Jochen Daum wrote:

Hi Kieran!

On Mon, 16 Feb 2004 19:50:00 +0000, Kieran Benton
<ki**********@fastmail.fm> wrote:

Hi everyone,
Sorry to bother you, have just spent the last few hours trying to solve
this. Have uncommented the line in php.ini, ensured the client tools are
installed. However when I try and view a PHP page now, the browser just
hangs indefinitely. If i take away the line in php.ini everything
returns to normal. Have heard I have to recompile with the freetds
library but am i not right in saying that is for unix/linux?

I think you are right. Do you use a named based resolution to get to
your SQL server or an IP address? Can you do

ping nameofsqlserver

telnet nameofsqlserver 1433
telnet ipaddressofsql 1433

Is SQL server listening on named pipes or tcp. Must be tcp afaik.

HTH, Jochen

--
Jochen Daum - Cabletalk Group Ltd.
PHP DB Edit Toolkit -- PHP scripts for building
database editing interfaces.
http://sourceforge.net/projects/phpdbedittk/