Installation: Setting up Your ProductCart Database

Last Updated: Jan 02, 2017 10:41AM EST

This document is meant as a general guideline for installing and setting up a Microsoft SQL Server database for NetSource Commerce's ProductCart shopping cart software. This is by no means a comprehensive guide for running a MS SQL Server-based database. For in-depth information on SQL Server, you should consult the documentation included with SQL Server or consult your Web hosting provider.

Creating the Database

If you have a Web hosting account that includes space on a shared SQL server, a database probably has already been setup for you, or there is a tool in the Web hosting account’s administration area that allows you to easily create one. If that’s the case, skip this section and go directly to “Running the SQL Script”.

If you need to create a new database, follow these directions.
  • In MS SQL Enterprise Manager, right-click on the “Databases” folder in the Server Manager window and select “New Database…”.
  • In the new database dialog box that appears, enter the name of the new database that you are going to use for ProductCart.
  • Click on “OK” to save the changes.
 

Running the SQL Script

You can now run the SQL script located in the productcart/database folder on your desktop. The script will create all the objects you need in the database.
  • If you created the database using a tool provided directly by the Web hosting company, that same tool will likely contain a utility that allows you to run a query. Load (or copy and paste) the ProductCart SQL script in that utility and run it.
  • Otherwise you can use a desktop application such as MS Enterprise Manager

Never run the SQL script mentioned above against a database that already contains data, including a database being used by an existing ProductCart-powered store.
 

Setting Permissions for the Database User

If a user name and password for the database were created through your Web hosting account administration area, you can skip this section as the user you setup already has the right permissions.

Otherwise, make sure that the database user that is used in the connection string that connects ProductCart to your SQL database has "ownership" rights on all the database objects: create a new User or select a User that has full permissions on all the tables in the ProductCart database. Make sure you are using SQL authentication, not Windows authentication.
 

Provider=sqloledb;Data Source=SERVER-IP,1433;Initial Catalog=DB-NAME;User Id=USER;Password=PWD; “SERVER-IP” is the server’s IP address “DB-NAME” is the name of the database “USER” and “PWD” are the user name and password that grant access to it

DSN Connection to a MS SQL database
DSN=SQLDSN;UID=USER;PWD=PWD
“SQLDSN” is the name of the DSN
“USER” and “PWD” are the user name and password that grant access to the database

 

Migrating from Access to SQL

Moving from an Access to a SQL database once the database has been populated and orders have been processed on the store is still possible, but it can be difficult and it may require hiring a database administrator (DBA). If you have a high-traffic Web site and therefore expect several concurrent users on your store (i.e. browsing and buying at the exact same time), you should definitely setup ProductCart to use a SQL database from the start.

If you need to move from an Access to a SQL database, you will need to contact a database administrator to assist you with the task. ProductCart can provide some recommendations based on feedback received from other ProductCart users.

647e99095133bd6d1ae916f97dc7f92f@productcart.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete