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: <xml FileVersion="5.1"> <credentials> <server name="SASApp" userid="XXXXXX" password="{SAS002}1XXXXXXXXXXXXXXXXXXXXXXXXXCB"/> </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
... View more