ProductCart Shopping Cart Software Forums : Converting Access to SQL help (it nearly worked) https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 12:48:55 +0000 Wed, 11 Nov 2009 08:37:45 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3181 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Converting Access to SQL help (it nearly worked) : To anyone else having trouble...]]> https://forum.productcart.com/converting-access-to-sql-help-it-nearly-worked_topic3181_post11937.html#11937 Author: Andy @ Landmarq
Subject: 3181
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. Clap]]> Wed, 11 Nov 2009 08:37:45 +0000 https://forum.productcart.com/converting-access-to-sql-help-it-nearly-worked_topic3181_post11937.html#11937 <![CDATA[Converting Access to SQL help (it nearly worked) : Hi Mark,Thanks for the reply,...]]> https://forum.productcart.com/converting-access-to-sql-help-it-nearly-worked_topic3181_post11878.html#11878 Author: Andy @ Landmarq
Subject: 3181
Posted: 05-November-2009 at 4:59am

Hi Mark,

Thanks for the reply, I shall drop you a mail.

Andy,
]]> Thu, 05 Nov 2009 04:59:33 +0000 https://forum.productcart.com/converting-access-to-sql-help-it-nearly-worked_topic3181_post11878.html#11878 <![CDATA[Converting Access to SQL help (it nearly worked) : How did you go about doing this...]]> https://forum.productcart.com/converting-access-to-sql-help-it-nearly-worked_topic3181_post11876.html#11876 Author: cognecy
Subject: 3181
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.
]]> Wed, 04 Nov 2009 15:06:58 +0000 https://forum.productcart.com/converting-access-to-sql-help-it-nearly-worked_topic3181_post11876.html#11876 <![CDATA[Converting Access to SQL help (it nearly worked) : Hello fellow carters,I have been...]]> https://forum.productcart.com/converting-access-to-sql-help-it-nearly-worked_topic3181_post11874.html#11874 Author: Andy @ Landmarq
Subject: 3181
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 :)


]]> Wed, 04 Nov 2009 11:57:24 +0000 https://forum.productcart.com/converting-access-to-sql-help-it-nearly-worked_topic3181_post11874.html#11874