AnsweredAssumed Answered

Error connecting FMP12 to MS SQL SERVER

Question asked by deraymen on Sep 10, 2013
Latest reply on Sep 10, 2013 by 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

Outcomes