Reading data from a SAS data source in .Net

Question

I was asked to read some data from SAS in an ASP.Net application. I have working code for a Windows Forms application. However, the same code does not work in ASP.Net, but I can try. A clean project with the same links fails consistently.

Here is what I got for the connection:

    SASWorkspaceManager.WorkspaceManager oWorkspaceManager
        = new SASWorkspaceManager.WorkspaceManager();
    string xmlInfo = "";

    SASWorkspaceManager.ServerDef oServerDef = new SASWorkspaceManager.ServerDef();
    oServerDef.MachineDNSName = "server";
    oServerDef.Protocol = SASWorkspaceManager.Protocols.ProtocolBridge;
    oServerDef.Port = <port>;
    oServerDef.BridgeEncryptionAlgorithm = "SASProprietary";
    oServerDef.BridgeEncryptionLevel = 
        SASWorkspaceManager.EncryptionLevels.EncryptUserAndPassword;

    SAS.Workspace oSASWorkspace = 
        oWorkspaceManager.Workspaces.CreateWorkspaceByServer ("", 
        SASWorkspaceManager.Visibility.VisibilityProcess, oServerDef, "user",
        "pass", out xmlInfo);

    oSASWorkspace.LanguageService.Submit(
        "proc means data = sashelp.class;output out=meanout;run;");
    OleDbDataAdapter oOleDbDataAdapter = new OleDbDataAdapter
                            ("select * from work.meanout",
        "provider=sas.iomprovider.1; SAS Workspace ID=" + 
        oSASWorkspace.UniqueIdentifier);
    DataSet oDS = new DataSet();
    oOleDbDataAdapter.Fill(oDS, "sasdata");

    oWorkspaceManager.Workspaces.RemoveWorkspaceByUUID(
        oSASWorkspace.UniqueIdentifier);
    oSASWorkspace.Close();

, " . , ". Trust = Full web.config, . , SAS , , SAS. -

OleDbDataAdapter oOleDbDataAdapter = new OleDbDataAdapter
                        (<Read Command>,
    "provider=sas.iomprovider.1; SAS Workspace ID=" + 
    oSASWorkspace.UniqueIdentifier);

, , , , , ASP.Net.

, , IIS, , . SAS - (, ) , , ASPNET SAS dev. - , ? .

Answer 1

SAS ? 9.13, WorkspaceManager ObjectManagerMulti ( ObjectManagerMulti2 9.2). , .

Answer 2

asp . , , , SAS Integration Technologies. . - gory.

Answer 3

- IIS. -, SAS Workspace → . , . → → , .

SASUSER config, .

C:\Program Files\SASHome\SASFoundation\9.3\nls\en\sasv9.cfg

/ * - SASUSER "? CSIDL_PERSONAL \ My SAS files \ 9.3" * / -SASUSER "c: \ sasuser"