DynamicUpdateCommand Returning False

[#1]

Hello

I am having a problem using DynamicUpdateCommand to insert a row into a SQL Server table in a Macro, only doing something simple at the moment

SET Inputting = ActiveDocument.DynamicUpdateCommand("INSERT INTO Campaign_Management (Name, CreatedAt,CreatedBy) VALUES (123, 2014-07-21 ,patxxx)").

I can do a select ok

This statement is returning false and when I try Inputting.ErrorMessage this returns just an empty string.

I have set the Server settings in my Document Properties as below

Any help would be appreciated