MS SQL Win32

[Wendell]

I've been using PHP for years, in a UNIX/Oracle/Linux/MySQL/etc
environment. Now I've got to get it up and running on a Win2K server,
IIS/5, SQL Server 2000. I've got PHP installed properly (using
5.0.0b2), phpinfo() does what you'd expect it to, so far so good.

However, when I include the `extension = php_mssql.dll` line in
php.ini, any subsequent request to a PHP script hangs, until
eventually the server times out and destroys the process. Full INI
contents:

cgi.force_redir ect = 0
extension_dir = c:\php5b2
extension = php_mssql.dll

Nothing else is going on, on the server, and it's a pretty beefy
server (quad Xeon). So something else is going on... Where should I
start looking? I'm a PHP-on-Windows noob :\

Thanks all!

[Google Mike]

Re: MS SQL Win32

ojailoop@yahoo. com (Wendell) wrote in message...[color=blue]
> I've been using PHP for years, in a UNIX/Oracle/Linux/MySQL/etc
> environment. Now I've got to get it up and running on a Win2K server,
> IIS/5, SQL Server 2000. I've got PHP installed properly (using
> 5.0.0b2), phpinfo() does what you'd expect it to, so far so good.
>
> However, when I include the `extension = php_mssql.dll` line in
> php.ini, any subsequent request to a PHP script hangs, until
> eventually the server times out and destroys the process. Full INI
> contents:
>
> cgi.force_redir ect = 0
> extension_dir = c:\php5b2
> extension = php_mssql.dll
>
> Nothing else is going on, on the server, and it's a pretty beefy
> server (quad Xeon). So something else is going on... Where should I
> start looking? I'm a PHP-on-Windows noob :\
>
> Thanks all![/color]

{ Aside -- My preference is not to run PHP on Windows. I'd install
RH9, which comes with PHP, MySQL, and PostgreSQL, ready-to-go. It's
more secure. }

Anyway, I imagine that the dll needs FreeTDS for Windows installed on
that server.

Another thing you could do, if you are desparate, is to abandon the
DLL and build your own multithreaded TCP socket server in VB6 or
C#.NET that does OLE DB interaction with MS SQL Server. Then, you
could use the PHP socket library to interact with that. I think you'll
be surprised with how fast this can be. You'll have to think up your
own security model, hacker protection, and data composition and
parsing, but it's well worth it to have everything under your own
control, imho.

Mike