Import SQL script failure

Discussion created by campfire on Jan 4, 2012
Latest reply on Jan 4, 2012 by campfire

I have an ODBC (Import DNS)import script that will execute without error locally on the server from within 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?