Connection String for ASP MVC app - Help

**Oldbie** · 06-30-2010, 10:49 AM

Hello,
I have an ASP.net MVC app and am trying to work out what I need to add to my connection string to connect it to my db.

The connection string provided by DiscountASP account is
"Data Source=tcp:esql2k802.discountasp.net;Initial Catalog=SQL2008_744874_lotusnukes;User ID=SQL2008_744874_lotusnukes_user;Password=******; "

and within my Web.config I have the following:
<connectionStrings>
<add name="ApplicationServices" connectionString="Data Source=tcp:esql2k802.discountasp.net;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|SQL2 008_744874_lotusnukes.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
<add name="LotusNukesConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\SQL2008_744874_lotusnukes.mdf;Initial Catalog=SQL2008_744874_lotusnukes;User ID=SQL2008_744874_lotusnukes_user;Password=*****;I ntegrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>

Can anyone point me in the right direction on what the ConnectionString should be please? I am new to web development.

Many thanks.

**Oldbie** · 07-01-2010, 11:34 AM

I managed to solve the issue. Typo in the connection string. doh!
Can't see an option to delete the post as I am so embarassed!
Lucky no one replied! lol

**mjp** · 07-01-2010, 11:38 AM

Thanks for following up.

No need to delete! Everyone makes that mistake a few hundred times during their lives.

And maybe someone will find this and it will remind them to check for typos.

06-30-2010, 10:49 AM	#1
Oldbie Join Date: Jun 2010 Posts: 2	Connection String for ASP MVC app - Help Hello, I have an ASP.net MVC app and am trying to work out what I need to add to my connection string to connect it to my db. The connection string provided by DiscountASP account is "Data Source=tcp:esql2k802.discountasp.net;Initial Catalog=SQL2008_744874_lotusnukes;User ID=SQL2008_744874_lotusnukes_user;Password=****; " and within my Web.config I have the following: <connectionStrings> <add name="ApplicationServices" connectionString="Data Source=tcp:esql2k802.discountasp.net;Integrated Security=SSPI;AttachDBFilename=\|DataDirectory\|SQL2 008_744874_lotusnukes.mdf;User Instance=true" providerName="System.Data.SqlClient"/> <add name="LotusNukesConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=\|DataDirector y\|\SQL2008_744874_lotusnukes.mdf;Initial Catalog=SQL2008_744874_lotusnukes;User ID=SQL2008_744874_lotusnukes_user;Password=***;I ntegrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/> </connectionStrings> Can anyone point me in the right direction on what the ConnectionString should be please? I am new to web development. Many thanks.

07-01-2010, 11:34 AM	#2
Oldbie Join Date: Jun 2010 Posts: 2	Solved I managed to solve the issue. Typo in the connection string. doh! Can't see an option to delete the post as I am so embarassed! Lucky no one replied! lol

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Noob question: what connection string to use at discountAsp.net?	PJ2010	Databases	4	03-03-2010 01:52 PM
A network-related or instance-specific error occurred while establishing a connection	froutoneagr	Databases	8	07-29-2009 09:21 AM
connection string	mary.a.b	Windows 2008/IIS 7	5	04-29-2008 12:15 PM
Maybe a connection String problem?	sbowcut	Databases	3	05-26-2007 03:36 AM
Encrypting and using LocalSqlServer connection string	uniquesjc	ASP.NET	1	01-27-2006 01:59 AM

07-01-2010, 11:38 AM	#3
mjp DiscountASP.NET Staff Join Date: May 2006 Posts: 2,315	Thanks for following up. No need to delete! Everyone makes that mistake a few hundred times during their lives. And maybe someone will find this and it will remind them to check for typos.