| แฟ้มประวัติPaul Galvin's SharePoint...บล็อกรายการSkyDrive | วิธีใช้ |
|
12 พฤศจิกายน Functional Example: BDC ADF that connects to SQL database with embedded user id and passwordI needed to wire up MOSS to a SQL database via BDC. For testing/POC purposes, I wanted to embed the SQL account user id and password in the ADF. Starting with this template (http://msdn2.microsoft.com/en-us/library/ms564221.aspx), I created an ADF that connects to a particular SQL server instance and logs in with a specific user id and password and shown in this snippet: <LobSystemInstances> <LobSystemInstance Name="ClaimsInstance"> <Properties> <Property Name="AuthenticationMode" Type="System.String">PassThrough</Property> <Property Name="DatabaseAccessProvider" Type="System.String">SqlServer</Property> <Property Name="RdbConnection Data Source" Type="System.String">actual server\actual instance</Property> <Property Name="RdbConnection Initial Catalog" Type="System.String">actual initial catalog</Property> <Property Name="RdbConnection Integrated Security" Type="System.String">SSPI</Property> <Property Name="RdbConnection Pooling" Type="System.String">false</Property> <!-- These are the key values: --> <Property Name="RdbConnection User ID" Type="System.String">actual User ID</Property> <Property Name="RdbConnection Password" Type="System.String">actual Password</Property> <Property Name="RdbConnection Trusted_Connection" Type="System.String">false</Property> </Properties> </LobSystemInstance> </LobSystemInstances> It is not a best practice, but it's useful for a quick and simple configuration for testing. This was surprisingly difficult to figure out. I never found a functional example with search keywords:
</end> ข้อคิดเห็น (4)
Paul Galvin
ปิดข้อคิดเห็นในเพจนี้
การติดตามข้อมูล (1)URL การติดตามข้อมูลสำหรับข้อมูลนี้คือ: http://paulgalvin.spaces.live.com/blog/cns!1CC1EDB3DAA9B8AA!320.trak เว็บล็อกที่อ้างอิงข้อมูลนี้
|
|
|