in

dashCommerce

An ASP.NET Open Source e-Commerce Application

Which ConnectionStrings to change?

Last post 02-16-2009 5:39 AM by Dick. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 02-15-2009 9:00 AM

    Which ConnectionStrings to change?

    I am having real trouble installing dashCommerce. The instruction was too trivial and incomplete.

    During install, I was advised to change the connectionString value (only 1 implied). There were 4 different connectionStringNAME (not just connectonString). Here are the four:

    #A: <add name="AspNetSqlRoleProvider" connectionStringName="dashCommerce" applicationName="dashCommerce" type="System.Web.Security.SqlRoleProvider"/>

    #B: <providers>
        <clear/>
        <add connectionStringName="dashCommerce" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="dashCommerce" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" passwordAttemptWindow="10" passwordStrengthRegularExpression="" minRequiredPasswordLength="4" minRequiredNonalphanumericCharacters="0" name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
       </providers>

    #C: <add name="SqlProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="dashCommerce" applicationName="dashCommerce"/>

    #D: <add name="dashCommerceProvider" connectionStringName="dashCommerce" type="SubSonic.SqlDataProvider, SubSonic"/>

    I changed all the instances of : connectionStringName="dashCommerce"

    to this: connectionStringName="Server=localhost;Initial Catalog=mydb;User Id=myid;Password=pwd;" providerName="System.Data.SqlClient" I did not change the application name or the type. Still it did not work. Can someone pls help me out here and tell me what I am doing wrong? Thanks!

    Filed under:
  • 02-16-2009 5:39 AM In reply to

    • Dick
    • Top 10 Contributor
    • Joined on 02-11-2008
    • Posts 102
    • dashCommerce Core Team
      Moderator

    Re: Which ConnectionStrings to change?

    You should leave those values. connectionStringName="xxx" means it will used a defined connectionstring with the name "xxx".

     If you open connectionStrings.config you will see the connectionstring, this is the value you should change, not the name.

Page 1 of 1 (2 items)