2 Replies Latest reply on Jan 4, 2012 2:34 PM by campfire

    Import SQL script failure


      I have an ODBC (Import DNS)import script that will execute without error locally on the server from within FMP.....works perfectly. (I'm importing data from a MS SQL server to update FM Student table, Teacher table, etc.)


      Then, same server, same script but this time executed from FMSA11 and it ignores the SQL/import script line and I see script error 802. The script does execute because I have some housekeeping stuff ( Go to Layout, Delete all records) that gets done correctly in the same script.


      I'm using a system DNS. All script steps are compatible with FM Server.


      What setup do I need for the FMS to talk to the MS SQL Server?