1 Reply Latest reply on Sep 10, 2013 3:19 PM by deraymen

    Error connecting FMP12 to MS SQL SERVER

    deraymen

      Title

      Error connecting FMP12 to MS SQL SERVER

      Post

           Hi,

           I apologize if this has been asked/dealt with before.  But I am trying to setup a FileMaker front End to a SQL SERVER database.  I have no issues that I can tell with updating or deleting, but when I try to create the a new record I have an error message to the effect that 

           "THE TARGET TABLE OF THE DML STATEMENT CANNOT HAVE ANY ENABLED TRIGGERS IF THE STATEMENT CONTAINS AN 'OUTPUT' CLAUSE WITHOUT 'INTO' Clause"

           I made sure to have all required fields have values (actually setup defaults).

           I was able to create a new record through an MS ACCESS interface no problem.  So I am guessing the issue is with the  FileMaker end

           Any hints would be great

           Thanks,

           deray