Getting Started - Setting Up Database Correctly

Print Page | Close Window

Setting Up Database Correctly

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Getting Started
Forum Description: Installing, activating, and getting started with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=2183
Printed Date: 06-October-2024 at 2:37am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Setting Up Database Correctly

Posted By: ericpollard
Subject: Setting Up Database Correctly
Date Posted: 24-November-2008 at 11:10pm

So everything is setup and ready to go, except this:

The connection string is valid, it appears that you have not yet populated your database. If you are using SQL, please run the required SQL Script to create the necessary tables in your database to use ProductCart.

How do I run the required SQL Script to create the necessary tables in my database? I found a couple mentions of this on EI's site, but no actual instructions. It is a MS SQL database if that is relevant at all...

Thanks to anyone who can help.

Replies:

Posted By: ProductCart
Date Posted: 24-November-2008 at 11:17pm

Hi Eric - please refer to the Quick Start instructions in our WIKI:

http://wiki.earlyimpact.com/productcart/install-db#creating_the_database - http://wiki.earlyimpact.com/productcart/install-db#creating_the_database

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: Greg Dinger
Date Posted: 24-November-2008 at 11:27pm

It's going to depend upon your host, and whether you have access to the database using SQL Studio (or Enterprise Manager), if they provide a browser-based SQL manager, or if there is no such access.

Either way, you need to look in the productcart/database folder and locate the .sql file. Open that in a text editor and paste it into the query editor supplied by whatever (see above) access you may have to your database. Run that script and the database will be populated.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |