IMacro stuck when ran from SQL xp_cmdshell

Discussions and Tech Support related to automating the iMacros Browser or Internet Explorer from any scripting and programming language, such as VBS (WSH), VBA, VB, Perl, Delphi, C# or C++.

Moderators: Community Moderators, iMacros Moderators

Forum rules
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the Google search box (at the top of each forum page) to see if a similar problem or question has already been addressed. This will search the entire contents of the forums as well as the iMacros Wiki.
3. We can respond much faster to your posts if you include the following information:

CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST

Answering your own posts (e.g. attempting to "bump" your topic) drops your topic from the list of unanswered threads, so it may actually receive less views.

IMacro stuck when ran from SQL xp_cmdshell

by Scout2Win on Sun Sep 06, 2015 6:07 am

Hello,

I have a SQL command inside a procedure:

SET @cmd='start /WAIT C:\Go.vbs'
EXEC master..xp_cmdshell @cmd;

The script just run this code:

set iim1= CreateObject ("imacros")
iret = iim1.iimOpen ()
iret = iim1.iimPlay("C:\NBA.iim")

If I run the script manually works fine.
If I execute the script through the SQL procedure, then the iMacro gets stuck on the line

URL GOTO=http://www.NBA.com

What I am making wrong?

Daniel
Scout2Win
 
Posts: 1
Joined: Sun Sep 06, 2015 5:57 am

Re: IMacro stuck when ran from SQL xp_cmdshell

by Tom, Tech Support on Mon Sep 07, 2015 4:02 am

Hi Scout2Win,

Is the Go.vbs script running in an interactive user session? It might be that this site does not load/work well unless it is running in such a session, e.g. under a user account that is logged in and has an active desktop.

For more information, Please see this article.
Regards,

Tom, iMacros Support
Tom, Tech Support
 
Posts: 3300
Joined: Mon May 31, 2010 9:59 am


Return to Scripting and Command Line Interface

Who is online

Users browsing this forum: No registered users and 3 guests

cron
-->