March 3, 200817 yr 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?
March 3, 200817 yr 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
March 3, 200817 yr 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
March 4, 200817 yr 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
Create an account or sign in to comment