including a connection string generates error in asp.net site

Question

I have set up a small SQL Server database for users to login and also create accounts. There is a problem with the connection string though. Whenever I use the connection string below in the web.config file I get a server error page and cannot view the website. However when I take out this connection string I am able to view the website albeit the database doesn't work. Any ideas would be greatly appreciated.

<configuration>
    <appSettings/>
    <connectionStrings>
        <addname="ConnectionString" connectionString="Server=.\SQLEXPRESS;Database=medicale_Members;User ID=user_admin;Password=medicalmembers;"/>
    <connectionStrings/>
    <system.web>

What does the error page say, and the connection string wasn't posted. — KallDrexx
– KallDrexx, Commented Aug 5, 2010 at 18:44

p.campbell · Accepted Answer · 2010-08-05 18:45:07Z

1

Unsure if it's a typo in your question, but you need to ensure your connection string element looks like:

 <add name

rather than

<addname

Ensure you close your element with

 </connectionStrings>

answered Aug 5, 2010 at 18:45

p.campbell

101k70 gold badges263 silver badges326 bronze badges

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

Comments

Dismissile · Accepted Answer · 2010-08-05 18:43:51Z

0

Change it to:

</connectionStrings>

Also as another person mentioned. Change the add to:

<add name ... />

answered Aug 5, 2010 at 18:43

Dismissile

33.1k40 gold badges179 silver badges269 bronze badges

1 Comment

pmoth81 Over a year ago

Thank you that was the problem

Collectives™ on Stack Overflow

including a connection string generates error in asp.net site

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related