Running a .vbs script via HTML/javascript/php on Cognos Report Studio

Question

I am trying to run a .vbs script on server side via code (HTML Item) on Cognos Report Studio. I have already tried using <a href="..\samples\scripts\script.vbs"> button </a> but it just opens the script text on browser.

I have tried this code below using PHP, but it did not work:

<?php
    function runScript(){
        exec("samples\scripts\script.vbs");
        echo("done");
    }
?>

<a href=# onclick="runScript();">

How could I do that?

EDIT: Both client and server are Windows machines.

Maybe duplicate : Run VBScript on server from javascript/php — ThinkTank
– ThinkTank, Commented Nov 12, 2015 at 12:52
I have tried the solution using 'wscript "../samples/scripts/script.vbs"' but it did not work too — Mumumurilo
– Mumumurilo, Commented Nov 12, 2015 at 13:02

ThinkTank · Accepted Answer · 2015-11-12 13:11:18Z

0

I think you do it the wrong way. Create 2 files :

I assume you activated COM class.

Page launcher.php :

<a href="executeVbScript.php">Execute VB</a>

Page executeVbScript.php

exec('wscript "C:/samples/scripts/script.vbs"');

Start with launcher.php page.

answered Nov 12, 2015 at 13:11

ThinkTank

1,1919 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mumumurilo Over a year ago

Thank you. I know I can create the executeVbScript.php on server, but I don't know if Cognos' HTML items are saved as .php files or .HTML files. I'll try it and if it works I'll mark it as answered.

ThinkTank Over a year ago

You mean the script must be run on client ?

Mumumurilo Over a year ago

No, the vbs must be run on server. I just don't know yet if Cognos' HTML items accept php commands. When I ran it the commands did not show up at the page, so I think it accepts.

Collectives™ on Stack Overflow

Running a .vbs script via HTML/javascript/php on Cognos Report Studio

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related