Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


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

4679 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

4679 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
0 Item(s)
$0.00
  • Your Cart Is Empty