Hi David Do these few queries ALWAYS fail, or just occasinally fail? Is this intranet site used by many people? If the same query always fails, you can determine if it may be a thread-safe issue by running that query outside of Apache as follows:
c:\php\php thequery.php If the above fails, then it is probably not due to the fact that the mssql extension is not thread safe. If it does work then it could be the problem. I am not familiar with Apache 2.0, but I do believe it is a multi-threaded server, which is not good for extensions that are not thread-safe. If Apache 2.0 cannot be configured to run as a multi-process server, you should consider using Apache 1.3. -- bob On Fri, 19 Mar 2004, david wrote: > Ah....thread safe. > > THAT is an interesting thought. Especially because I somehow suspect that my > problem is related to the database and/or table being locked just when I am > trying to read it. > > However, I have to profess some ignorance about FastCGI. I looked at the web > site for it, but I am not sure if by installing it I am now magically > thread-safe? Or, once installed, do I need to make some code changes? > > My environment is an established intranet (Windows based; Windows 2000 > server, Apache 2.0; connecting over the network to MS SQL Server, also > running on Windows 2000). What is odd is that there are only a couple of > queries that fail, and when they do, they ONLY fail against certain tables > used for reporting from a data warehouse, and then only now and then > (perhaps once a day; maybe less). The queries are dynamic in nature, and can > pull data of integer, char, or varchar. All other queries (and there are a > rather lot of them) for doing the mundane intranet stuff work perfectly, and > have NEVER failed. It is a real puzzle. > > Thanks! > david > > "Frank M. Kromann" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Hi David, > > > > You problem might be a thread safty issue. the MSSQL extension is not > > thread safe (caused by the Microsoft Library used to create the > > extension). Use CGI or FastCGI to avoid this problem. > > > > - Frank > > > > P.S. I don't have the full thread of this discussion so I might miss some > > important information about your setup. > > > > > Bruno: > > > > > > I did that. I had to wait a bit until it failed again, whcih it did a > > few > > > moments ago. Alas, there is not one thing out of the ordinary in the > > log. > > > > > > Any other suggestions? > > > > > > THANK YOU! > > > david > > > > > > "Bruno Ferreira" <[EMAIL PROTECTED]> wrote in message > > > news:[EMAIL PROTECTED] > > > > david wrote: > > > > > > > > >Hello there! > > > > > > > > > >I have just about driven myself crazy with an odd intermittent > > problem. > > > > >[snip] > > > > > > > > > > > > > > > > > > I'd first start by turning on all logging I could in the SQL > > server > > > > so that I could see what's happening straight from the horse's > > mouth... > > > > > > > > Bruno Ferreira > > > > --- > > > > [This E-mail scanned for viruses by Declude Virus] > > > > > > > > -- > > > > PHP Database Mailing List (http://www.php.net/) > > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
