excel odc 连接 SQL server 定死 pssword

1. <odc:Connection odc:Type="OLEDB">
   
2.    <odc:ConnectionString>rovider=SQLOLEDB.1ersist Security Info=True;User ID=XXX;Data Source=192.168.1.18\XXX;Use Procedure for Prepare=1;Auto Translate=Trueacket Size=4096;Workstation ID=XXXX;Use Encryption for Data=False;Tag with column collation when possible=False;Initial Catalog=XXX; PWD=XXXX</odc:ConnectionString>
   
3.    <odc:CommandType>Table</odc:CommandType>
   
4.    <odc:CommandText>"MyCampus"."dbo"."Ex_Cre_RetakeListing"</odc:CommandText>
   
5.    <odc:AlwaysUseConnectionFile/>
   
6.   </odc:Connection>

复制代码