connection to database ?

can i have multiple user and password in a connection string ??

for example :

<add name="strCon" connectionString="Data Source=test;Initial Catalog=test;User=test, guest;Password=test, guest" providerName="System.Data.SqlClient" />-

or is there any other way ??

the reason is that i have created a view that hits 2 database that requires user info and pass ...........any advice is appreciated

Just put two connection strings in your web.config and in the area that says add name="" give them separate names. In your datalayer you will have to allow for this. When it is calling from one database call the appropriate connection string. When it is the other use the second connection string.

I hope that this helps.|||thanks for the info...........