How to create a connection string in webconfig

[DeveloperLife2015]

Hi All, I want to connect to a SQL Server database saved on URL database name fc000xststsql01.IVRCallCenterTest server address http://ma001xsicmw91/IVRControllerAppProd/Home/ what would be the connection string I will use in web config file ? Thanks

[Vani Kulkarni]

Take a look at following links: store-connection-string-in-web-config[^] setting-up-connection-string-in-asp-net-to-sql-server[^] For Reading connection string in code: How to : Read Connection string from Web.Config[^]

Thanks & Regards, Vani Kulkarni

[DeveloperLife2015]

hi Vani, the examples in these pages are just talking about a SQL Server database that is local on the same hard drive but how to connect to a database on a URL Thanks

[Aatif Ali from Bangalore]

<connectionStrings>
<add name="REOU_DB" connectionString="Data Source=AMT-03;Initial Catalog=reouLive11-sep-2012;Persist Security Info=True;User ID=sa;Password=amt12345" providerName="System.Data.SqlClient" />

</connectionStrings>

:thumbsup:

Aatif