How do you create the dashCommerce3 RC1 store SQL database?

Last post 05-12-2008 10:50 PM by yocuteem. 7 replies.

Page 1 of 1 (8 items)
	Sort Posts: Previous Next

04-16-2008 12:02 AM

kwcoffee1
Joined on 04-13-2008
Posts 14

How do you create the dashCommerce3 RC1 store SQL database?

Reply Contact

Hi,

I'm very new to the dashCommerce starter kit and also to the SQL EXPRESS database engine. I downloaded the dashCommerce3 RC1 application and un-zipped it. But I don't see an obvious .mdf database file or a .sql script file to create a store database. Can someone tell me how to create or download the a sample SQL database file to use with the dashCommerce3 starter kit?

Thanks,

King

04-16-2008 12:13 AM In reply to

yitzchok
Joined on 02-11-2008
New York
Posts 476

Re: How do you create the dashCommerce3 RC1 store SQL database?

Reply Contact

First start off by reading the ReadMe.txt file located in the Web folder

You have to create the database yourself using SQL Server Management Studio (Express)
The installer will insert the sql files (if you want to run them yourself you can find it Web\install\scripts)

Find a bug? Create a Work Item for a fast response.. Want to help? Create a patch for us!

04-16-2008 2:02 AM In reply to

dataworm
Joined on 04-07-2008
Posts 2

Re: How do you create the dashCommerce3 RC1 store SQL database?

Reply Contact

I don't think that the readme.txt mentions the DB setup steps. But if you look under the Documentation link you will find two pdf files that you can download that are quite helpful in getting started.

Installing Microsoft SQL Server 2005 Express Edition with Advanced Services
http://dashcommerce.org/files/folders/installation/entry766.aspx

Installing dashCommerce
http://dashcommerce.org/files/folders/installation/entry1700.aspx

Good Luck.

04-16-2008 7:51 PM In reply to

kwcoffee1
Joined on 04-13-2008
Posts 14

Re: How do you create the dashCommerce3 RC1 store SQL database?

Reply Contact

I created an empty database file (per instructions) and then tried to run the web/install/install.aspx file from within MS VWD app... I get the server error below.

The empty database container is completely empty, including has no tables defs.

How do I get around this new error?

Thanks,

King

Server Error in '/' Application.

Invalid object name 'dbo.dashCommerce_Core_ConfigurationData'.

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.Data.SqlClient.SqlException: Invalid object name 'dbo.dashCommerce_Core_ConfigurationData'.

Source Error:

Line 96:       Validator.ValidateStringArgumentIsNotNullOrEmptyString(configurationSectionName, CONFIGURATION_SECTION_NAME);
Line 97: 
Line 98:       ConfigurationDatumCollection configurationDatumCollection = new ConfigurationDatumCollection().
Line 99:         Where(ConfigurationDatum.Columns.Name, configurationSectionName).
Line 100:        Load();

Source File: C:\Users\owner\General Files\dashCommerce\dashCommerce\Core\Controllers\ConfigurationDatumController.cs Line: 98

Stack Trace:

[SqlException (0x80131904): Invalid object name 'dbo.dashCommerce_Core_ConfigurationData'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
   System.Data.SqlClient.SqlDataReader.get_MetaData() +62
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +62
   SubSonic.SqlDataProvider.GetReader(QueryCommand qry) +303
   SubSonic.DataService.GetReader(QueryCommand cmd) +47
   SubSonic.Query.ExecuteReader() +35
   SubSonic.AbstractList`2.Load() +491
   MettleSystems.dashCommerce.Core.ConfigurationDatumController.FetchConfigurationByName(String configurationSectionName) in C:\Users\owner\General Files\dashCommerce\dashCommerce\Core\Controllers\ConfigurationDatumController.cs:98
   MettleSystems.dashCommerce.Core.Configuration.DatabaseConfigurationProvider.FetchConfigurationByName(String configurationSectionName) in C:\Users\owner\General Files\dashCommerce\dashCommerce\Core\Configuration\DatabaseConfigurationProvider.cs:121
   MettleSystems.dashCommerce.Store.SiteSettings.Load() in C:\Users\owner\General Files\dashCommerce\dashCommerce\Core\SiteSettings.cs:136
   MettleSystems.dashCommerce.Store.Web.SiteMasterPage.get_SiteSettings() in C:\Users\owner\General Files\dashCommerce\dashCommerce\Store\Web\SiteMasterPage.cs:96
   MettleSystems.dashCommerce.Web.site.Page_Load(Object sender, EventArgs e) in C:\Users\owner\General Files\dashCommerce\dashCommerce\Web\site.master.cs:115
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

04-16-2008 8:33 PM In reply to

yitzchok
Joined on 02-11-2008
New York
Posts 476

Re: How do you create the dashCommerce3 RC1 store SQL database?

Reply Contact

You are missing the connection string check this (But this should only come up after the installer)

Find a bug? Create a Work Item for a fast response.. Want to help? Create a patch for us!

04-16-2008 9:35 PM In reply to

kwcoffee1
Joined on 04-13-2008
Posts 14

Re: How do you create the dashCommerce3 RC1 store SQL database?

Reply Contact

Maybe it will help if I give you the connect string I'm using and the SQL login account.

The active "web/connectingstring.config" line I'm using is:

I created a SQL authentication login: username: dashCommerce, password: dashCommce.

The empty database file name is dashCommerce.

King

04-16-2008 11:39 PM In reply to

kwcoffee1
Joined on 04-13-2008
Posts 14

Re: How do you create the dashCommerce3 RC1 store SQL database?

Reply Contact

The reason for the error message was a result of running the install.aspx file from within the MS VWD app. I misstatenly assume that it was running by default - because, it was the last thing I selected before hitting the run hotkey. Nevertheless, I got through the login process... but now I have IIS configuration problems.

Thanks for your assistance,

King

05-12-2008 10:50 PM In reply to

yocuteem
Joined on 03-17-2008
Philadelphia Area
Posts 64

Re: How do you create the dashCommerce3 RC1 store SQL database?

Reply Contact

Here's another thing to keep in mind if you run into this error: "Invalid object name 'dbo.dashCommerce_Core_ConfigurationData'". I wanted to test the installation to see if I could help out, so I created a new empty database and then attempted to run the install.aspx, and lo and behold I got the "Invalid object name 'dbo.dashCommerce_Core_ConfigurationData'" error. The problem was that I had the Exceptions (in VS 2008) setup to break on any Common Language Runtime Exception that was thrown. This was because I was debugging another application and left this setting turned on.

To check your settings, or to turn this off, go to the Debug - Exceptions menu in VS IDE, and then uncheck the "Thrown" checkbox next to "Common Language Runtime Exceptions". I believe that is the only way that you will get this error about the "invalid object name". I hope this post helps someone in the future.

Tim

Page 1 of 1 (8 items)