I am seeing similar issues.
Also having scripts that will run locally but not on server 12.
There are no items that are not server supported in my scripts.
My backend is Oracle. Issues with various ODBC activities.
Also having scripts that will run locally but not on server 12
Not all script steps are compatible when script is run from a server schedule. Use the compatibility drop down in the Script Editor to check for compatibility.
Even steps that are compatible, may have server specific limitations that keep them from working as expected:
Import and Export script steps are two such steps. Only certain very specific locations and file types can be specified as the source for an import or the destination for an export.
Thus, you can easily get a script that works fine from a client and not from a server schedule.
See this KB article for more on the subject: http://help.filemaker.com/app/answers/detail/a_id/7035/kw/server%20import%20records
Thanks Phil, I went through the comaptibilty check and the kb article prior to posting the problem. The kb article just doesn't provide info on ODBC connections, other than "In addition, importing from an ODBC data source is supported."