RE: [PHP-DB] Problems with 4.3.10 and SQL Server

Does the mssql account user have the correct priviledges to be able to run those queries? Are you using proper error reporting to see if there are any error messages returned by mssql wrt those queries? (are you using http://ca3.php.net/manual/en/function.mssql-get-last-message.php to get the last message from the server)? bastien

From: "aifoundations.org" <aifoundations@zoominternet.net> To: <php-db@lists.php.net> Subject: [PHP-DB] Problems with 4.3.10 and SQL Server Date: Sun, 13 Mar 2005 18:01:38 -0500 I don't see many SQL Server posts here but I will give it a shot. I am using PHP 4.3.10, SQL Server 2000, and W2000. I have had no problems with scripting against PHP 5.x but I have had real problems when running these same scripts against 4.3.10. For example, all my select and insert statements do nothing. Submitting truncate commands against the database work, but a simple query like "insert into input values('$lines')" do nothing. Again, I have had no problems with 5.x. Any general suggestions or tricks to try. I have tried things such as fully quoting table names, bracketing the name, using 2 single quotes instead of 1. None of these suggestions work however. Jim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php