I have written a vbscript to run SAS code file in EG. I have set up the server to automatically run the vbscript. Both of these work fine on my computer. However, when I try to set up the server to automatically run the vbscript, it fails because the task is being run by the SASAdmin account, and I get the error cannot connect to SASMain. I am not sure if this is standard for EG, but EG is set up to check the info in the personal login manager against the account info you used to log into windows.
My question is, in the vbscript, when I call the sasprogram, can I set the credentials for SAS so it runs on the server, but uses my credentials. I can enter my username and password, and then compile the script as an exe. Here is my code:
On Error Resume Next
ProjectName = "\\Nasvs1\Shared\4700Mac\Shared3\Actuarial\SAS\Projects\Refresh.egp"
Files = Array("LIBNAMES", "DAILY")
Call Work(ProjectName, Files)
Sub Work(ProjectName, Files)
Set App = CreateObject("SASEGObjectModel.Application.4")
Set Project = App.Open(ProjectName,"")
Set Container = Project.CodeCollection
For Each File In Files
For Each Object In Container
If Object.Name = File Then Object.Run
Next
Next
Project.Save
Project.Close
End Sub
Any help is greatly appreciated.
Thanks,
Chris
... View more