首页 > 数据库技术 > 详细

SharePoint 通过Oledb链接本地SSAS中的CUBE

时间:2015-10-23 17:53:23      阅读:335      评论:0      收藏:0      [点我收藏+]

public static OleDbConnection Connection()
{

string connectionstring = "Provider=MSOLAP.4;Integrated Security=SSPI;Persist Security Info=True;" +
"Initial Catalog=“数据库名”;Data Source=“服务器名”;MDX Compatibility=1;" +
"Safety Options=2;MDX Missing Member Mode=Error";
SPSecurity.RunWithElevatedPrivileges(delegate()  //要加上这句话 获取最高权限 不然会出现没有权限的错误
{
if (connection == null)
{
connection = new OleDbConnection(connectionstring);
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Closed)
{

connection.Open();


}
else if (connection.State == System.Data.ConnectionState.Broken)
{
connection.Close();
connection.Open();
}
});
return connection;


}

SharePoint 通过Oledb链接本地SSAS中的CUBE

原文:http://www.cnblogs.com/loveLu/p/4904819.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!