|
|
Posted by Chung Leong on 07/26/06 18:13
Joshua Ruppert wrote:
> We're using ODBC instead of the direct MSSQL drivers for one, and we
> are using the standard odbc_connect() function. Are there any known
> problems using ODBC with MS SQL Server?
I'm not too familiar with ODBC. The SQL Server ODBC driver does
connection pooling. With standard CGI you'd get a new connection
everytime, whereas the connection would be reused in FastCGI. As your
application works in CGI but no in FastCGI, that's a good place to
look.
It could also be that you were experiencing deadlocks before, only that
IIS was terminating the process.
I'm sort of out of ideas. You might want to reproduce the condition (on
a test environment of course), then run sp_who/sp_who2 in Query
Analyser to see what is actually happening. It'd also be interesting to
see if the PHP processes would unfreeze if you stop SQLServer.
> Wouldn't the service login be the Web Server service login? So to
> control the PHP login I would need to change the Web service login?
Nevermind. I mistakenly thought the installer adds PHP as a service.
Navigation:
[Reply to this message]
|