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?