I have Mysql 5.5.15, and Toad for Data analysis 2.7. I have a simple automation script which contains connection to mysql, plus a sql scripts contains one line only: call my_proc()when I run the sql script at the editor it works fine, but with the automation it failed and gives me “Timestamp Message9/3/2011 3:31:51 PM Execution Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘D:\toad_script_files\sql_call_prcdr.sql’ at line 1”Please What would be the problem.
I need to consult the mySQL Developer. Unfortunately is is on vacation this week. I will check with him when he gets back.
This seems to work for me. Can you post the script that you using in automation that gives the error? I am probably using too simple of a script.