ProductCart Shopping Cart Software Forums : Problem moving database to a new server https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 05:52:07 +0000 Mon, 08 Feb 2010 13:57:02 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3410 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Problem moving database to a new server : I appreciate the suggestion. Unfortunately,...]]> https://forum.productcart.com/problem-moving-database-to-a-new-server_topic3410_post12897.html#12897 Author: redbeetstudio
Subject: 3410
Posted: 08-February-2010 at 1:57pm

I appreciate the suggestion. Unfortunately, I do not have a support contract with Early Impact and I don't want to pay $200. thanks.

- peter]]> Mon, 08 Feb 2010 13:57:02 +0000 https://forum.productcart.com/problem-moving-database-to-a-new-server_topic3410_post12897.html#12897 <![CDATA[Problem moving database to a new server : I suggest that you file support...]]> https://forum.productcart.com/problem-moving-database-to-a-new-server_topic3410_post12896.html#12896 Author: Greg Dinger
Subject: 3410
Posted: 08-February-2010 at 1:37pm

I suggest that you file support ticket with EI.  Something is causing dberror.asp to be displayed.  What that might be cannot be determined without FTP access and physically examining thing.]]> Mon, 08 Feb 2010 13:37:04 +0000 https://forum.productcart.com/problem-moving-database-to-a-new-server_topic3410_post12896.html#12896 <![CDATA[Problem moving database to a new server : Thanks Greg. I&#039;ve changed...]]> https://forum.productcart.com/problem-moving-database-to-a-new-server_topic3410_post12895.html#12895 Author: redbeetstudio
Subject: 3410
Posted: 08-February-2010 at 1:30pm

Thanks Greg. I've changed the db string (left scCrypPass alone), but I'm having database problems when attempting to login through front-end. Everything else is working fine. Any idea what might be causing the problem?]]> Mon, 08 Feb 2010 13:30:52 +0000 https://forum.productcart.com/problem-moving-database-to-a-new-server_topic3410_post12895.html#12895 <![CDATA[Problem moving database to a new server : That is your license key. If changed,...]]> https://forum.productcart.com/problem-moving-database-to-a-new-server_topic3410_post12893.html#12893 Author: Greg Dinger
Subject: 3410
Posted: 08-February-2010 at 1:23pm

That is your license key.  If changed, encrypted information in your store will become unreadable. 
 
If your database is moved, what you need to change is the db connection string that appears below that.
]]> Mon, 08 Feb 2010 13:23:59 +0000 https://forum.productcart.com/problem-moving-database-to-a-new-server_topic3410_post12893.html#12893 <![CDATA[Problem moving database to a new server : In storeconstants.asp, what is...]]> https://forum.productcart.com/problem-moving-database-to-a-new-server_topic3410_post12891.html#12891 Author: redbeetstudio
Subject: 3410
Posted: 08-February-2010 at 1:00pm

In storeconstants.asp, what is the following variable used for? And does it need to be changed if the dtabase is moved?

private const scCrypPass
]]> Mon, 08 Feb 2010 13:00:48 +0000 https://forum.productcart.com/problem-moving-database-to-a-new-server_topic3410_post12891.html#12891 <![CDATA[Problem moving database to a new server : I have been having problems with...]]> https://forum.productcart.com/problem-moving-database-to-a-new-server_topic3410_post12846.html#12846 Author: redbeetstudio
Subject: 3410
Posted: 05-February-2010 at 12:01pm

I have been having problems with my current MSSQL2005 server, so I've decided to move my PC database to a new server. The site files will not be moved, only the database.

I have had server technicians copy the database to the new server so that I can test everything before I make the switch. To test, I have edited the storeconstants.asp file to the reflect the new server connection. I can see that the store is in fact connecting to the new SQL server (I made a simple edit to a product and can see it reflected in the store). I can also navigate the store, add products to the cart, etc. without problems.

But when I try to log into an existing account, either to place an order or view account details, I receive the following error: "An error has occured in this store. We apologize for the inconvenience... The error has been logged in the store database. The reference ID for this error is: . Write it down..." As you can see there is no reference ID, so I cannot look into the specifics of the error.

Is there something else I need to do besides change the connection details in storeconstants.asp? I can see the account in both databases, so I assume that the database has been copied properly. The error also occurs if I try to setup a new account during checkout.
]]> Fri, 05 Feb 2010 12:01:17 +0000 https://forum.productcart.com/problem-moving-database-to-a-new-server_topic3410_post12846.html#12846