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 [EMAIL PROTECTED] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problems with 4.3.10 and SQL Server
- Original Message - From: Bastien Koert [EMAIL PROTECTED] Newsgroups: php.db To: [EMAIL PROTECTED]; php-db@lists.php.net Sent: Sunday, March 13, 2005 6:19 PM Subject: 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? Yes, everything I am trying to script has been confirmed to work against the database. 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)? Yes, I've tried it and I even directly queried @@ERROR. Nothing is diplayed using mssql_get_last_message, and @@ERROR displays 0. I suppose this must mean I am not connecting to the database. I wonder if there is ping command I could run to confirm I have proper access to the server. I am running this against the database of a host company so I'm not sure what the problem could be. phpinfo reports that SQL Server support exists. Oh vey, I just checked it again. I really screwed that one up. Apparently, there is no SQL Server support on the host server. I better work out this problem before worrying about 4.3.10 vs. 5.x differences. Thanks for your help. Jim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php