With what user name is the server entering your files?
And if this a correct username, are the correct privilege settings present to connect to your files with ODBC?
I'm not sure I understand your question...the files are hosted on the fm server. If I run the script via fm pro, it connects to database, pulls data and updates data. I connect the the database as an "admin" with full rights/priveliges.
I set up a schedule to run the script via the admin console, used the same username/pwd to access the database and run the script. That is when I get the error messages, 802 and 3.
OK, in that case, did you check the permissions on the folders where the files are you aree trying to pull in?
Even though you access with your admin username / pw, the access to the folders is from fmserver (at least on Mac).
(my first comment was because sometimes an additional user (server) is added to the solution to bypass certain steps in openings scripts).
You have to set up an ODBC DSN on the FM Server machine itself. It should be setup EXACTLY like the DSN that works, that you have on your local computer.
Did you solve the problem? I'm stuck with exactly the same problem. Running the ODBC Sync Script directly from a FileMaker client works fine. The same Script executed by the server doesn't work. (I've to admit that I used an FM Advanced client on the same server in order to make sure that the ODBC settings are identical).
If I'm right this should have nothing to do with the restriction that FMServer wants his files in his documents folder?!