campfire

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 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?

Outcomes