Excel工作表的外部数据源中,终于不再有连接用户的密码,困扰了好久的Excel Service 的安全问题终于解决了,后面有时间会有详细的说明。
<odc:Connection odc:Type="OLEDB">
<odc:ConnectionString>
Provider=SQLOLEDB.1;
Integrated Security=SSPI;
Persist Security Info=True;
User ID=dataaccesser;
Initial Catalog=AdventureWorks;
Data Source=aerbin-sql2005\portal;
Use Procedure for Prepare=1;
Auto Translate=True;
Packet Size=4096;
Workstation ID=AERBIN-MOSS;
Use Encryption for Data=False;
Tag with column collation when possible=False
</odc:ConnectionString>
<odc:CommandType>Table</odc:CommandType>
<odc:CommandText>"AdventureWorks"."Sales"."vSalesPersonSalesByFiscalYears"</odc:CommandText>
<odc:CredentialsMethod>None</odc:CredentialsMethod>
</odc:Connection>
</odc:OfficeDataConnection>