Execution from Enterprise Guide in CMD

ocauser — Tue, 21 Jul 2015 18:37:30 GMT

Hi all

I'm accessing remotely to a server (A), which has the Enterprise guide installed. In Enterprise Guide, I'm using a profile(connection) to a sas server in another machine(B), where are all the libraries.

The server(A) has the following installations:

Enterprise Guide 5.1 (64bit)

Integration Technologies Configuration

Manage Sas File Types

Install Qualification Tool

(sas_instalations.png)

(1)

I have developed a simple *.egp file in EG (A), which access a data-set, do a query builder transformation, and do a export step to a csv file in the server (A).

I have generated the VBS, and I'm trying to execute that in a Command Line Session, with the 64bit windows cscript and I'm having an error.

"Permission Denied"

C:\windows\system32\cscript.exe H:\Filipe_Vieira\DEVS\EGScript9.vbs ( this is the command I'm using)

(2)

I am now using a credentials.xml file, that's in the following location (according to sas troubleshooting page)

%allusersprofile%\SAS\SharedSettings\5.1\credentials.xml

the code of my credentials.xml is:

</credentials>

</xml>

(3)

I've built a egp file to pwencode my user password in a program, which i then use in the credentials.xml file. This is the code I'm using there:

proc pwencode in='MyPassword'; run;

(4)

I have debuged the problem a bit and found that the problem starts with a CreateObject statement. In the meanwhile, I have reduced my VBS code in order to contain the error origin and I am trying to run a simple code I found in the internet, with a simple CreateObject statement for SAS.

C:\windows\system32\cscript.exe H:\Filipe_Vieira\DEVS\EGScript1.vbs

EGScript1.vbs

'force declaration of variables in VB Script

Option Explicit

Dim Application

On Error Resume Next

Set Application = CreateObject("SASEGObjectModel.Application.5.1")

If Err.Number <> 0 Then

WScript.Echo "Error: " & Err.Description

MsgBox "Error: " & Err.Description

Else

WScript.Echo Application.Name & ", Version: " & Application.Version

Application.Quit

End If

I do not understand why this code isn't working and I'm running out of options to solve this, so I really could use some input from you guys

Apart this option is there any alternatives? How could i run my EGP file?

thanks in advance

Re: Execution from Enterprise Guide in CMD

ocauser — Wed, 22 Jul 2015 11:01:50 GMT

Just one aditional note. If i remove the credentials.xml from its place, I get the desired output in cmd line for EGScript1.vbs, however, I also get this strange pop up (attached)

Re: Execution from Enterprise Guide in CMD

RW9 — Wed, 22 Jul 2015 12:02:40 GMT

Speak to your IT support for this application. Explain what you want to do. They should be able to provide a solution. It looks like you do not have access of a certain kind. Why do you need to use VB script to run your project in the first place? Is it scheduling, then your IT support should provide scheduling software and help you set it up.

topic Re: Execution from Enterprise Guide in CMD in SAS Procedures

Execution from Enterprise Guide in CMD

Re: Execution from Enterprise Guide in CMD

Re: Execution from Enterprise Guide in CMD