insert/delete/Update with MSSQL

[Anon]

Hi !

I've got a little problem using a "execute statement" (insert,update,delete,execute) with this configuration : MSSQL 2000, PHP4, W2K AND APACHE.

When i send such a statement :

Insert [MYDATABASE].[OWNER].[MYTABLE] ('COLUMN1','COLUMN2','COLUMN3) VALUES 'NOTHING1','NOTHING2','NOTHING3'

Apache doesn't return any error wich is quite normal. I also can trace my query in the SQL Profiler, nothing special happens.
the connexion is established, the 'exec sp_server_info 18' is executed to look for the collation settings of the server. Then the 'use [MYDATABASE]' is normally send, then the statement is send...

Nothing abnormall so, except the row is not inserted.

If the same query is sent on a table wich contain a identity column, the identity is updated (another insert with isqlw will insert in the identity column the next value) but the row is still not inserted...

Any ideas ? (arrrrrghgh 🙂)

[Anon]

Last minute Precision :

The previous example DOES work with the Personal Edition of SQL2k but not with the Standard Edition.

Please answer before I'll open the window 🙂

[Anon]

What a great day !
Four hours on that f... problem :
My MSSQL configuration was the problem :
the IMPLICIT TRANSACTION PARAMETER
was set to ON, and PHP doesn't know what to do with such a configuration, even if it reads it before to send any transaction.
To say things simply, the transaction was started but never commited...