Specifying user id and password in application defination file for BDC

Hi,

To specify connection string with user id and password we need to have the following things in the application defination file (.xml)

<?xml version=“1.0“?>

<LobSystem xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance“ xmlns:schemaLocation=“http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.XSD“ Type=“Database“ Version=“1.0.0.0“ Name=“NorthwindLOBSystem“ xmlns=“http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog“>

<Properties>

<Property Name=“WildcardCharacter“ Type=“System.String“>%</Property>

</Properties>

<LobSystemInstances>

<LobSystemInstance Name=“NorthwindInstance“>

<Properties>

<Property Name=“DatabaseAccessProvider“ Type=“System.String“>SqlServer</Property>

<Property Name=“AuthenticationMode“ Type=“System.String“>PassThrough</Property>

<Property Name=“RdbConnection Data Source“ Type=“System.String“>d-2926</Property>

<Property Name=“RdbConnection Integrated Security“ Type=“System.String“ />

<Property Name=“RdbConnection Initial Catalog“ Type=“System.String“>Northwind</Property>

<Property Name=“RdbConnection User ID“ Type=“System.String“>sa</Property>

<Property Name=“RdbConnection Password“ Type=“System.String“>sa</Property>

<Property Name=“RdbConnection Pooling“ Type=“System.String“>false</Property>

</Properties>

</LobSystemInstance>

</LobSystemInstances>

<Entities>

We need not to specify any value for Integrated Security as we are using sql authentication

And can specify user id and password with RdbConnection User ID and Password Property.

Bye…