connection string

Mar 29, 2013 at 11:47 PM
I changed the prodinner connstr to be compatible with the db I have (sql server 2012 developer).
<add name="Db" connectionString="Data Source=(local)\foxjazz;Database=prodinner;UID=foxjazz;pwd=StartMe2;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient"/>

It says can't connect, but I find I can connect ok otherwise.

I have also tried localhost\foxjazz

Any ideas?
Coordinator
Mar 30, 2013 at 12:33 AM
try generating the connection string using visual studio after paste it in the web.config, maybe this will help:
http://www.c-sharpcorner.com/uploadfile/suthish_nair/how-to-generate-or-find-connection-string-from-visual-studio/