Setting Up Database Correctly

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

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.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ericpollard Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 16-November-2008 Status: Offline Points: 0	Post Options Post Reply Quote ericpollard Report Post Thanks(0) Quote Reply Topic: Setting Up Database Correctly 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.

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply 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
	The ProductCart Team Home of ProductCart shopping cart software

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply 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.