VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 Installation Sql - database issues
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

34 Posts

Posted - January 11 2009 :  12:50:12  Show Profile  Visit sachi's Homepage  Reply with Quote
Its been about a week since i got hold of Vpasp and i am yet to take the first step - i just tried to install a copy on my local server and i am running into trouble already.

I just dont know how to have a Sql database installed - is there a Step by Step Guide for Sql Server installation + Vpasp installation ( i know the quick start guie does give the info for config )

I just tried things out and ran into the following issues -

1) When installing Sql Server - i chose windows authentication.
2) Then i tried to change it to Sql Authentication.
3) I forgot to note the password ( or did it even ask for one am not sure - but i think i did guess the password later ), while i installed the Ms Sql server 2005 express edition.
4) when every thing was done and when i tried to run the convertsql.asp this was the error message ..

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Technical Information (for support personnel)

* Error Type:
ADODB.Connection (0x800A0E78)
Operation is not allowed when the object is closed.
/vpasp/shopproductsubs2.asp, line 141

* Browser Type:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv: Gecko/2008120122 Firefox/3.0.5

* Page:
GET /vpasp/shoperror.asp

Any help from anyone should be nice - am trying to have vpasp installed and quickly design some templates.

Welcome to the world of Candle Expression



4286 Posts

Posted - January 11 2009 :  20:57:43  Show Profile  Visit support's Homepage  Reply with Quote
Hi there

There is a file called diag_dbtest.asp that will let you know if you have successfully connected to SQL.

If you are struggling with SQL locally it may be best to start off with Access and then when you publish to the live site use our Access to SQL conversion tool to move all of your data and settings across into the SQL database.

Alternatively if you post a ticket in our helpdesk our support guys may be able to assist.


VPASP Support
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000