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-ASP Shopping Cart Customer Forum

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

 All Forums
 VPCart Forum
 VP-ASP set-up problems
 ADODB.Connection Error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mcrane
Starting Member

9 Posts

Posted - March 18 2007 :  22:32:32  Show Profile  Reply with Quote
All,

I'm a newbie so be kind. I'm attempting to install the software on my test server (Windows XP Pro). I receive the following error when I try to enter my site from my local machine.

ADODB.Connection (0x800A0E78)
Operation is not allowed when the object is closed.
/shopping/shop$db.asp, line 1411

I have made the following modifications before trying to connect (I'm trying to follow the quick setup guide):

1.Modified the shop$config.asp file by adding my order #
2.Setup the NTFS permissions to read/write on the database folder
3.Removed read access within ISS on the database folder

Reading c:\inetpub\wwwroot\shopping\$readme.txt PASS!
Reading c:\inetpub\wwwroot\shopping\images\shim.gif PASS!
Reading c:\inetpub\wwwroot\shopping\database\shopping650.mdb PASS!

Regards,

Mike

Edited by - mcrane on March 18 2007 22:39:35

support
Administrator

4266 Posts

Posted - March 19 2007 :  01:28:20  Show Profile  Visit support's Homepage  Reply with Quote
Hi Mike,

Welcome aboard!

Is the database still in its default location?

If so is there a way we can view your test site over the internet? If not you may need to post a ticket in our online Help Desk so our support team can help get you up and running.

https://www.vpasp.com/virtprog/helpdesk

Thanks
Cam

VP-ASP Support
Go to Top of Page

mcrane
Starting Member

9 Posts

Posted - March 19 2007 :  06:41:52  Show Profile  Reply with Quote
The DB is is the original location of C:\Inetpub\wwwroot\shopping\database
Go to Top of Page

support
Administrator

4266 Posts

Posted - March 19 2007 :  08:31:26  Show Profile  Visit support's Homepage  Reply with Quote
Try setting your shop$config.asp as follows:

const xDatabase="shopping650" 'Database name
const xdblocation="C:\Inetpub\wwwroot\shopping\database" 'location of database relative to VP-ASP files

'NOTE - XDATABASETYPE SHOULD BE ENTERED IN UPPER CASE LETTERS
'const xdatabasetype="" ' Database type: leave empty for Access or change to one of the options shown below
'const xdatabasetype="ODBC"
const xdatabasetype="Drive"
'const xdatabasetype="SQLServer"
'const xdatabasetype="MYSQL"
'const xdatabasetype="MYSQL351"
'const xdatabasetype="ACCESS2007"

You also need to make sure you have set the relevant permissions on the database folder.

Thanks
Cam

VP-ASP Support
Go to Top of Page

mcrane
Starting Member

9 Posts

Posted - March 19 2007 :  08:48:34  Show Profile  Reply with Quote
I receive this error after making that change:

Error Type:
Server.MapPath(), ASP 0172 (0x80004005)
The Path parameter for the MapPath method must be a virtual path. A physical path was used.
/shopping/shop$db.asp, line 333
Go to Top of Page

RKSTech
Starting Member

United Kingdom
12 Posts

Posted - May 08 2007 :  18:43:54  Show Profile  Visit RKSTech's Homepage  Reply with Quote
Hi Got the same problem

Any resolution for this

SEO services from 50 per month at www.rkstech.co.uk
Go to Top of Page

RKSTech
Starting Member

United Kingdom
12 Posts

Posted - May 08 2007 :  18:58:53  Show Profile  Visit RKSTech's Homepage  Reply with Quote
Tried this it works

const xDatabase="shopping650" 'Database name
const xdblocation="\shopping\database"


SEO services from 50 per month at www.rkstech.co.uk
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000