[PHP-DB] Re: SQL Server Query Failed

2004-03-19 Thread david
Ahthread 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

Re: [PHP-DB] Re: SQL Server Query Failed

2004-03-19 Thread Robert Twitty
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,

[PHP-DB] Re: SQL Server Query Failed

2004-03-18 Thread david
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

Re: [PHP-DB] Re: SQL Server Query Failed

2004-03-18 Thread Frank M. Kromann
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

[PHP-DB] Re: SQL Server Query Failed

2004-03-17 Thread david
Bob: Is this case, PhaseFK is an integer. However, it will fail on character fields as well. Thanks! david Robert Twitty [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] What type of field is PhaseFK? -- bob On Wed, 17 Mar 2004, david wrote: Hello there! I have just about

Re: [PHP-DB] Re: SQL Server Query Failed

2004-03-17 Thread Robert Twitty
Hi David There does not appear to be any reason why you are having problems. Try using the odbtp/mssql hybrid extension at http://odbtp.sourceforge.net. It uses Microsoft's ODBC driver for SQL Server. The mssql extension on Windows uses DB-Library, which Microsoft stop supporting after SQL Server