MS SQL - SAMPLE CONNECTION STRING (ASP.NET)

Web Hosting India - Windows Web Hosting and Linux Web Hosting Discussions

MS SQL - SAMPLE CONNECTION STRING (ASP.NET)

Postby webhostingindia » Sun Mar 18, 2012 11:14 am

This is a sample connection string which you can use with MS SQL 2005 / 2008 under ASP.NET:

<connectionStrings>
<add name="connStr" providerName="System.Data.SqlClient" connectionString="Data Source=localhost;Initial Catalog=XXXX;User ID=XXXXX;Password=XXXXX;" />
</connectionStrings>

For security reasons, we have changed specific settings with XXXX

NOTE: You MUST include the full database name, which consit of the user prefix and the name that you have given, for example XXX_DB
webhostingindia
 
Posts: 51
Joined: Sun Mar 11, 2012 4:46 pm

Return to Web Hosting India - General Discussions

Who is online

Users browsing this forum: No registered users and 1 guest

cron