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@xxxxxxxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Subject: 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
