I'm trying to open up SAS Enterprise from VBA to call upon/run a different program. But I'm getting an error "2147213310 (80042002)" which I'm confused about (I've attached the exact error message). This is the first time I've tried to connect from VBA to SAS so everything I have so far has been picked from codes I've found in other forums. Dim obObjectFactory As New SASObjectManager.ObjectFactory Dim obObjectKeeper As New SASObjectManager.ObjectKeeper Dim obServer As New SASObjectManager.ServerDef Dim obSAS As SAS.Workspace Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset obServer.MachineDNSName = "DummyName" obServer.Protocol = ProtocolBridge obServer.Port = 8591 obObjectFactory.LogEnabled = True Set obSAS = obObjectFactory.CreateObjectByServer("My Server", True, obServer, "MyUserName", "MyPassword") The error is when I run the last line. The SAS Profile I'm trying to connect to has been attached too. I have seen some stuff around about issues running on 32-bit SAS but I have no idea how to get around this? Has anyone come across this issue before? Thank you,
... View more