Couldn't describe it in the title, but here's problem I'm having.
I have a VBScript that gets ItemID from 3rd party App and puts it into temp table and executes VB executable with Wait option like this:
Set objWSH = CreateObject("WScript.Shell")
objWSH.Run """\\Alyssa\Steve\Clients\ASI\ASI.exe""",1,True
VB executable connects to a database, gets some values and populates options on form fo user to select.
If I run my VB app alone, it gets data from DB and populates controls.
If I execute it from VBScript, my form comes blank, with no data populated.
Strangely, if I put a msgbox in VB app where I connect to DB, then it would run OK from VB script and populate form controls correctly.
What am I missing here?
Thanks for your input.
Steve
I have a VBScript that gets ItemID from 3rd party App and puts it into temp table and executes VB executable with Wait option like this:
Set objWSH = CreateObject("WScript.Shell")
objWSH.Run """\\Alyssa\Steve\Clients\ASI\ASI.exe""",1,True
VB executable connects to a database, gets some values and populates options on form fo user to select.
If I run my VB app alone, it gets data from DB and populates controls.
If I execute it from VBScript, my form comes blank, with no data populated.
Strangely, if I put a msgbox in VB app where I connect to DB, then it would run OK from VB script and populate form controls correctly.
What am I missing here?
Thanks for your input.
Steve