Converting Access to SQL help (it nearly worked)
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=3181
Printed Date: 28-February-2025 at 9:00pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Converting Access to SQL help (it nearly worked)
Posted By: Andy @ Landmarq
Subject: Converting Access to SQL help (it nearly worked)
Date Posted: 04-November-2009 at 11:57am
|
Hello fellow carters, I have been given the wonderous task of trying to convert our access driven store over to sql, after a bit of reading and such I managed to convert all the data over correctly as far as I could see and when I hooked it up to our store everything looked to be running as it should. However the BTO section seems a bit broke, you can browse and select a BTO item but trying to add to cart or customise it causes it to generate an error message, looking at the error log I am getting this message. Invalid column name 'pcProd_showBTOCMMsg'.<p>query=SELECT quantityFrom,quantityUntil,discountperUnit,percentage,discountperWUnit,baseproductonly FROM discountsPerQuantity WHERE IDProduct=3355</p> The BTO items do have a price next to them so I guess they are semi working in some form. The only thing I can see that is different between the access and sql version are the relationships are missing, is this the most likely cause or am I missing something else? As always any advice greatfully received :) ------------- Need a bespoke PC built to order? come to www.landmarq.co.uk |
Replies:
Posted By: cognecy
Date Posted: 04-November-2009 at 3:06pm
|
How did you go about doing this conversion if I might ask? I have been doing ProductCart Database conversions for several years now and I can tell you that 'getting it right' is not a trivial task. As for the error you are seeing, it could be any number of things but it looks like you may have used something like the 'Access Upsizing Wizard' (which will always break the ProductCart DB relationships). If that is the case, it is best to just start over rather than trying to repair the problem.
If you would like to talk one on one about this give me a call or shoot me an email. You are 6 hours ahead of me in the UK so I would likely be able to get back with you around 3-4 PM your time. ------------- Mark Shipp Cognecy Solutions, LLC Hosting/Design/Customization/Database Migration www.cognecy.com www.cognecy.co.uk |
Posted By: Andy @ Landmarq
Date Posted: 05-November-2009 at 4:59am
|
Hi Mark, Thanks for the reply, I shall drop you a mail. Andy, ------------- Need a bespoke PC built to order? come to www.landmarq.co.uk |
Posted By: Andy @ Landmarq
Date Posted: 11-November-2009 at 8:37am
|
To anyone else having trouble with Product Cart and SQL Mark is the man you need to talk to after a few hiccups relating to my peculiar SQL database hosting he got me all sorted and my site now runs like a dream. I can highly recommend his talents to anyone in need. 
------------- Need a bespoke PC built to order? come to www.landmarq.co.uk |