Run script on server

[Jokez]

Hi! I have created a script that runs fine when I run it from a Filemaker client. Now I want it to run directly from the Filemaker Server Advanced. The script reads from a table and goes to layouts that is based on MySQL tables. There it is suppose to do updates live to our MySQL database but when I add the script to the sceduler on my Filemaker Server and it runs it does nothing. Can this be done?

[Steven H. Blackwell]

Did the Account you provided in the Admin Console to run the script have privileges to create records in the MySQL table.

Also, what do the logs say about this?

Steven

[Jokez]

Yes It run with full priviliges..

[Steven H. Blackwell]

Yes It run with full priviliges..

No. What are its privileges in the SQL table, not the FileMaker file? It must have privileges to create and write data in the SQL table.

Steven

[Jokez]

Ah how do I set that??

[Steven H. Blackwell]

Ah how do I set that??

The SQL DBA must give you an account with those privileges and your DSN to access the file must include that information.

Steven