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" <frank@xxxxxxxxxxxx> wrote in message news:10796513604800000@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx > 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" <blueroom@xxxxxxxxxxxxxxxx> wrote in message > > news:405882ED.80803@xxxxxxxxxxxxxxxxxxx > > > 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
