Error connecting FMP12 to MS SQL SERVER
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
It appears this might also be an issue on the SQL Server side.. I am finding a number of entries on the internet with just SQL Server. But I don't see anything definitive (or that makes sense to me)