ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Getting Started
  New Posts New Posts RSS Feed - Running Initial SQL query
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Running Initial SQL query

 Post Reply Post Reply
Author
Message
bcrabtree View Drop Down
Groupie
Groupie
Avatar

Joined: 31-January-2008
Location: United States
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote bcrabtree Quote  Post ReplyReply Direct Link To This Post Topic: Running Initial SQL query
    Posted: 31-January-2008 at 1:45am
Hi,

This may be kind of a dumb question, but how and where do I run the initial
SQL query to populate my database with the necessary tables and fields to
get started with Product Cart.

I'm lost on this one. Please help.
Back to Top
netprofits View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers


Joined: 05-January-2006
Location: United States
Status: Offline
Points: 22
Post Options Post Options   Thanks (0) Thanks(0)   Quote netprofits Quote  Post ReplyReply Direct Link To This Post Posted: 31-January-2008 at 6:24am

The quick answer is by using SQL Query Analyzer. See the User's Guide page 25 (Setting Up the MS SQL database) for complete details. You will need to have your SQL connection information including SQL server location (either a URL or IP address), database name, username and password. These should have been provided by your web hosting service. If not, either contact them or you may be able to use your web hosting control panel to create the database or check for this information.

SQL Query Analyzer is installed with SQL Enterprise Manager. If you don't have that installed, you will either need to have your hosting service setup the database, or sometimes the web hosting control panel has a query analyzer type tool built in which you can use or you will need to hire a Product Cart developer to setup the database for you.

NetProfits Internet Consulting

Certified ProductCart Developer

Our Site
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238
Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post Posted: 31-January-2008 at 7:00am

A couple other points.  If your host is running a later version of MSSQL, you can download Microsoft's "SQL Server Management Studio Express" for free, and use that. 

For MSSQL 2000, you may still be able to find their download of MSSQL Enterprise Manager. 

If you are on GoDadddy, they forbid the use of such remote connection tools and you will have to use the online tool they have buried in their control panel.

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.047 seconds.