首页新闻找找看学习计划

SQL2005 System.Security.Permissions.FileIOPermissi

0
悬赏园豆:20 [已解决问题] 解决于 2009-04-01 22:50

在vs2005下编写的存储过程代码如下:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using System.Xml;
public partial class StoredProcedures
{
    [Microsoft.SqlServer.Server.SqlProcedure]
    public static void StoredProcedure1()
    {
        SqlConnection cnn = new SqlConnection("context connection=true");
        cnn.Open();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = cnn;
        cmd.CommandText = "select * from UserTest for xml raw('pesron')";
        XmlReader xr = cmd.ExecuteXmlReader();
        DataSet ds = new DataSet();
        ds.ReadXml(xr);
        ds.WriteXml("d://wu.xml");
    }
};

在sql2005下执行该存储过程时,出现以下错误:
消息 6522,级别 16,状态 1,过程 StoredProcedure1,第 0 行
在执行用户定义例程或聚合 'StoredProcedure1' 期间出现 .NET Framework 错误:
System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
System.Security.SecurityException:
  at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
  at System.Security.CodeAccessPermission.Demand()
  at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
  at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
  at System.Xml.XmlTextWriter..ctor(String filename, Encoding encoding)
  at System.Data.DataSet.WriteXml(String fileName, XmlWriteMode mode)
  at System.Data.DataSet.WriteXml(String fileName)
  at StoredProcedures.StoredProcedure1()

谢谢!

吴晨晖的主页 吴晨晖 | 初学一级 | 园豆:180
提问于:2009-04-01 00:20
< >
分享
最佳答案
0

把 d: 盘指定为 Every One 完全控制 

再试这个

ALTER ASSEMBLY <you_assembly_name> WITH PERMISSION_SET=EXTERNAL_ACCESS

参见 http://social.msdn.microsoft.com/Forums/en-US/sqlnetfx/thread/15ae5ce0-d212-4b74-811a-67f4ab94bebf/

eaglet | 专家六级 |园豆:17119 | 2009-04-01 06:11
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册