Mr_Phil Posted October 12, 2006 Share Posted October 12, 2006 (edited) Thanks to some help on this forum I've managed to get my AUTOIT script running. The story so far- The script will happily: 1) accept two arguments; a URL and a filename 2) open Firefox showing the URL 3) save as a PDf via Adobe professional / distiller using the second parameter as a fileneame 4) shut down firefox. This all works super happily when I run it manually. However, when I try to run it from a SQL SERVER stored procedure it simply hangs. If I log onto the server where it is running, I can see an AUTOIT processes churning away. If I kill the process, then the stored procedure completes. Is it possible to run AUTOIT scripts offline, and in particular the kind of thing I'm trying to do? If not, any alternatives? Thanks in advance Phil. Edited October 12, 2006 by Mr_Phil Link to comment Share on other sites More sharing options...
Blue_Drache Posted October 12, 2006 Share Posted October 12, 2006 Thanks to some help on this forum I've managed to get my AUTOIT script running.The story so far-The script will happily:1) accept two arguments; a URL and a filename2) open Firefox showing the URL3) save as a PDf via Adobe professional / distiller using the second parameter as a fileneame4) shut down firefox.This all works super happily when I run it manually. However, when I try to run it from a SQL SERVER stored procedure it simply hangs. If I log onto the server where it is running, I can see an AUTOIT processes churning away. If I kill the process, then the stored procedure completes.Is it possible to run AUTOIT scripts offline, and in particular the kind of thing I'm trying to do?If not, any alternatives?Thanks in advancePhil.Does your program calling the AutoIt script have administrator rights, or the proper permissions to save files? Lofting the cyberwinds on teknoleather wings, I am...The Blue Drache Link to comment Share on other sites More sharing options...
Mr_Phil Posted October 12, 2006 Author Share Posted October 12, 2006 Does your program calling the AutoIt script have administrator rights, or the proper permissions to save files?I think so. The calling program is SQL server, so it has local admin rights.I have set the permissions on Firefox and Adobe Professional to 'everybody execute'.The target folder is 'everybody write'.Also, I know that using 'everybody' is kinda dangerous, but I want to get it working first, then tighten up on the security.Is what I'm attempting possible, at least in theory?Phil. Link to comment Share on other sites More sharing options...
Mr_Phil Posted October 13, 2006 Author Share Posted October 13, 2006 Update: the AUTOIT process is being run under the Administrator account, so it shouldn't have any problems with permissions. I've just noticed that the firefox step is being performed. I have a 'floating' firefox process in addition to the AUTOIT one. I'm wondering if AUTOIT is unable to detect the firefox window becoming active when I'm not actually logged it. Can anybody shed any light on this issue at all? Thanks Phil. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now