从 .Net 中的 SAS 数据源读取数据_C#/.NET开发问题-跟版网

本文介绍了从 .Net 中的 SAS 数据源读取数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着跟版网的小编来一起学习吧！

问题描述

有人要求我在 ASP.Net 应用程序中从 SAS 读取一些数据.我有一个 Windows 窗体应用程序的工作代码.然而，相同的代码不在 ASP.Net 中工作，但我可以尝试.具有相同引用的干净项目始终失败.

I've been asked to read some data from SAS in an ASP.Net application. I've got working code for a Windows Forms app. However the same code doesn't work in ASP.Net however I can try it. A clean project with the same references consistently fails.

这是我为连接准备的:

    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 的连接时失败.无论出于何种原因，片段

With just that it fails initialising the data adapter with an inner exception of "Attempted to read or write protected memory. This is often an indication that other memory is corrupt." If I add Trust=Full to the web.config file I get the same error directly when filling the data adapter. We can prove that executing the SAS command via the workspace manager is working, it's when we then try to read the results back that it fails when initialising the connection to SAS. For whatever reason, the fragment

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

这似乎到处都被引用为如何做到这一点只是在通过 ASP.Net 运行时不断引发错误.

which seems to be cited everywhere as how to do it just keeps raising an error when run through ASP.Net.

我猜这是某个地方的用户权限问题，它不喜欢在 IIS 用户下运行，但不知道需要授予它什么权限.某处或其他地方的一些 SAS 文档(抱歉，找不到)建议确保用户具有权限，但 ASPNET 用户确实可以完全访问开发机器上的整个 SAS 程序目录.有谁知道我还需要设置什么?谢谢.

I'm guessing it's a user permissions issue somewhere with it not liking running under the IIS user but wouldn't know what needs permissions granted to it. Some SAS documentations somewhere or other (sorry, can't find it) suggested making sure the user had permissions, but the ASPNET user does have full access to the whole SAS program directory on the dev machine. Does anyone know what else I might need to set? Thanks.

从 .Net 中的 SAS 数据源读取数据

问题描述

推荐答案

相关文档推荐