in

dashCommerce

An ASP.NET Open Source e-Commerce Application

Connection String

Last post 10-15-2010 10:34 PM by fvortizjr. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 05-28-2010 1:44 PM

    • DanD
    • Not Ranked
    • Joined on 05-28-2010
    • Posts 1

    Connection String

    Hello,
    I'm new to this product and right from the beginning it makes me go crazy.
    Installation process went ok, test connection to DB
    DB has all tables and some data in.
    Manually update ConnectionString file
    At the last Installation step  it’s telling me all went OK please remove Installation folder
    I click Next got an Error
    Please make sure that you setup the Database, and the Connection String in the connectionString.config file.

    Went to Web Config and Set
    Disable <customErrors mode="Off"/>
    <compilation debug="true">
    Didn’t do much:
    Please make sure that you setup the Database, and the Connection String in the connectionString.config file.
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Exception: Please make sure that you setup the Database, and the Connection String in the connectionString.config file.

    Source Error:

    [No relevant source lines]

    Source File: c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\bc8ea5bb\56f05b17\App_Web_jggzhztq.5.cs    Line: 0

    My connection string:
    <connectionStrings>
      <clear />
    <add name="dashCommerce" connectionString="Server=172.16.1.100;Initial Catalog=testdb; User Id=wu01;Password=Hg4ytZrV57lfVR;"  providerName="System.Data.SqlClient" />
    </connectionStrings>

    Where is my problem?
    Thank you in advance. Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
  • 05-30-2010 6:06 AM In reply to

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

    Re: Connection String

    Hello,

    I think you should put a port number behind your server IP, like Server=172.16.1.100,1433

  • 06-17-2010 5:07 AM In reply to

    Re: Connection String

    I  faced the same issue in my development environment, but I did not encounter this issue in my production environment.

    I got around this problem (I don’t consider my approach a good solution) by  modifying the Web.Debug.config and Web.Release.config as follow:

     

    I replaced:

    </configSections>

      <connectionStrings configSource="connectionString.config" />

     

    With :

     <connectionStrings>  <clear />  <add name="dashCommerce" connectionString="Server=mySQLserverName;Initial Catalog=myDatabaseName;User Id=MyuserName;Password=myPassword;" providerName="System.Data.SqlClient" />

    </connectionStrings>

     

    Please let me know if this works for you as well. Thanks

    Chris, or anybody, what do you think the problem is?

      

     


    Cheers,
    Monoot
  • 06-17-2010 10:39 AM In reply to

    Re: Connection String

    I think there may be another error occurring somewhere, but the DB connection string error is getting thrown as a result. You may want to set a breakpoint on that "catch" and see if there are any errors to that point. I've never seen this, so I'm relying on you folks to give me more info. Thanks.
    --
    Big Smile ~ Chris

    Open Source = Community = Shared Responsibility = Submit A Patch!
  • 10-15-2010 10:34 PM In reply to

    Re: Connection String

    I thought you had to provide read and write access to the aspnet(xp) or network service(ms server) in order for the site to load.  I also had to add aspnet as a login to ms sql server and give it rights.  It loaded fine for me after that.

Page 1 of 1 (5 items)