database server name change

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
JWL Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 15-August-2008 Status: Offline Points: 0	Post Options Post Reply Quote JWL Report Post Thanks(0) Quote Reply Topic: database server name change 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.

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply 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 shopping cart software

JWL Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 15-August-2008 Status: Offline Points: 0	Post Options Post Reply Quote JWL Report Post Thanks(0) Quote Reply Posted: 24-February-2009 at 9:18am
	Got it, thanks.

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply 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.