i have a problem with adding a connection string into the web.config file

Question

I want to add a connection string and give it name..

The connection string belongs to aspnetdb.mdf which was created when i added my CreateUserWizard.

This is its connection string:

Data Source=.\SQLEXPRESS;AttachDbFilename="D:\Documents and Settings\Dima\My Documents\Visual Studio 2010\WebSites\WebSite10\App_Data\ASPNETDB.MDF";Integrated Security=True;User Instance=True

Now when i add it to the config file:

    <connectionStrings>
        <add name="YourGuruDB" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="D:\Documents and Settings\Dima\My Documents\Visual Studio 2010\WebSites\WebSite10\App_Data\ASPNETDB.MDF";Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
  </connectionStrings>

it shows me weird line underneath of part of the string which prevents it from being executed..

I also dont understand the connection between the membership config and the database

    <membership defaultProvider="MyMembershipProvider">

What is this provider? Shouldnt it be .NET Framework provider? Same as the aspnetDB

Also why do i see red Xes on the databases i created/and the system created whenever i open my server explorer?

Mark Redman · Accepted Answer · 2011-05-25 16:02:31Z

1

try taking out the double quotes within the connectionString="" attribute.

answered May 25, 2011 at 16:02

Mark Redman

24.6k20 gold badges99 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Danny Varod Over a year ago

Use single quotes instead, if your sub-string contains spaces.

Dmitry Makovetskiyd Over a year ago

what about the red X that appears on my database that is in my Server explorer

Collectives™ on Stack Overflow

i have a problem with adding a connection string into the web.config file

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related