ProductCart Shopping Cart Software Forums : database server name change https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 08:28:08 +0000 Tue, 24 Feb 2009 10:00:09 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=2509 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[database server name change : JWL - I have no idea what your...]]> https://forum.productcart.com/database-server-name-change_topic2509_post9070.html#9070 Author: Greg Dinger
Subject: 2509
Posted: 24-February-2009 at 10:00am

JWL - I have no idea what your site is, thus I have not replied to your recent posts about error messages.  Now that I see that you are with (ughh) Godaddy, that gives me some clues.
 
Did this e-mail come as a result of your contacting Godaddy about the errors?  If not, then it may simply be overloaded servers or other environmental issues at the host that are resulting in these errors.
]]> Tue, 24 Feb 2009 10:00:09 +0000 https://forum.productcart.com/database-server-name-change_topic2509_post9070.html#9070 <![CDATA[database server name change : Got it, thanks. ]]> https://forum.productcart.com/database-server-name-change_topic2509_post9069.html#9069 Author: JWL
Subject: 2509
Posted: 24-February-2009 at 9:18am

Got it, thanks.]]> Tue, 24 Feb 2009 09:18:14 +0000 https://forum.productcart.com/database-server-name-change_topic2509_post9069.html#9069 <![CDATA[database server name change : Yes, you need to update the database...]]> https://forum.productcart.com/database-server-name-change_topic2509_post9068.html#9068 Author: ProductCart
Subject: 2509
Posted: 24-February-2009 at 7:33am

Yes, you need to update the database connection string in the file "include/storeconstants.asp". The database connection string typically looks like this:

Provider=sqloledb;Data Source=SERVER-IP,1433;Initial Catalog=DB-NAME;User Id=USER;Password=PWD;
 
 “SERVER-IP” is the server’s IP address
 “DB-NAME” is the name of the database
 “USER” and “PWD” are the user name and password that grant access to it

You will need to change the part that says "Server-IP", which will currently include your existing server name and needs to be changed to the new one.
]]> Tue, 24 Feb 2009 07:33:14 +0000 https://forum.productcart.com/database-server-name-change_topic2509_post9068.html#9068 <![CDATA[database server name change : I just got this from Godaddy hosting,...]]> https://forum.productcart.com/database-server-name-change_topic2509_post9067.html#9067 Author: JWL
Subject: 2509
Posted: 24-February-2009 at 6:40am

I just got this from Godaddy hosting, do I need to change anything in PC?!

This is to inform you that the database server name used to 
connect to database xxxxxx has been changed from:

xxxxxxx.secureserver.net

to

xxxxxxx.hostedresource.com

You will see the new database name in the Hosting Control 
Center and database administration tools. This change has 
no immediate affect on your site.

To update your site code, modify the database connection 
string to reflect the new database server name. This can be 
done at any time, as the old database server name is still in 
operation. Updating as soon as possible, however, ensures future 
connectivity should your database be moved to a new server for 
hosting account changes or infrastructure improvements.  

Databases set up with DSNs have been updated automatically. 
No action is required on your part to update site code that 
uses DSNs.
]]> Tue, 24 Feb 2009 06:40:15 +0000 https://forum.productcart.com/database-server-name-change_topic2509_post9067.html#9067