11-16-2011 11:24 AM
we have a bunch of Excel/VBA-programs to do our reporting.
Our data we select from a SQL-DB.
Now we changed our DB to SAS.
I'm now trying to connect to SAS to use the reporting as it is, but the connection doesn't work.
I use the following code to build up a connection to SAS.
Dim obObjectFactory As New SASObjectManager.ObjectFactory
Dim obServer As New SASObjectManager.ServerDef
Dim sasWS As sas.Workspace
obServer.MachineDNSName = "lcub1sa"
obServer.Protocol = SASObjectManager.Protocols.ProtocolBridge
obServer.Port = 18561
Set sasWS = obObjectFactory.CreateObjectByServer("My_Prod_Data", True, obServer, "myusername", "mypassword")
When running this code i get an exception
"SASMessage severity = "Error" : The client has connected to a SAS (9.2) Metadata Server (v1.0) when it intended to connect to a SAS Workspace Server."
Any ideas to avoid this exception and to set up a valid connection are wellcome.