Customizing ProductCart - database server name change

Print Page | Close Window

database server name change

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=2509
Printed Date: 14-October-2025 at 2:56am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: database server name change

Posted By: JWL
Subject: database server name change
Date 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.

Replies:

Posted By: ProductCart
Date 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.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: JWL
Date Posted: 24-February-2009 at 9:18am

Got it, thanks.

Posted By: Greg Dinger
Date 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.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |