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…