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 6.50 Features and Facilities
 2 websites 1 database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rmgolf
VP-ASP New User

United Kingdom
76 Posts

Posted - November 29 2011 :  10:41:13  Show Profile  Reply with Quote
Help
I am trying to setup a second website using the same database have created a new folder on my localhost wwwroot and copied my original site into it, then I made the changes as described on page 201 of the Ver 6.5 users manual, this seems to be working if I select a product in the main database and change the productmatch to store2 it no longer shows in the main store.
But when I try and access the second store I get the following error.

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/shop/default.asp, line 136


Below is a copy of line 136 in default.asp

Sub WriteImpressions
contentdbc.execute("UPDATE content SET impressions = 0 WHERE impressions IS NULL")
if contentid <> "" then
'increment content impressions
contentdbc.execute("UPDATE content SET impressions = impressions + 1 WHERE contentid = " & contentid)
Else
If messagetype <> "" Then
contentdbc.execute("UPDATE content SET impressions = impressions + 1 WHERE messagetype LIKE '" & messagetype &"'")
End If
End If
End Sub%>



Can anybody help with this or is there a clearer instructions to be found anywhere on how to achieve two websites running from a single Access database.

Bob

carfin
VP-ASP Expert

United Kingdom
948 Posts

Posted - November 29 2011 :  11:58:56  Show Profile  Reply with Quote
Hi Bob,

seems likely to be a permissions problem with the database not allowing access from the 2nd site. I would suggest contacting the support guys unless someone else can help out soon.

Regards,

Carrol
www.deanston-electrical.co.uk
Go to Top of Page

diegomilito
VP-ASP Expert

Argentina
723 Posts

Posted - January 06 2012 :  03:52:32  Show Profile  Reply with Quote
Bob, are you using Access db ? if yes, can you try asking web host guys to enable read/write permission to the db folder and db file ?

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