Customizing ProductCart - Having issues trying to connect database to site

Print Page | Close Window

Having issues trying to connect database to site

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=2329
Printed Date: 22-July-2025 at 11:23am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Having issues trying to connect database to site

Posted By: BlackReefDesigns
Subject: Having issues trying to connect database to site
Date Posted: 09-January-2009 at 10:19pm

Hello -

We are trying to move the site 'adxtactical.com' to a new GoDaddy.com Virtual Server from a shared-hosting account.

I have temporarily pointed the Virtual Server to the adxtactical.net domain to test the site, etc.

After everything is complete, I will rename the Virtual Server to the .com name and close the old shared-hosting account.

Anyways - first issue is the adxtactical.net site is running VERY slow, but I am hoping this specific issue is related to the issue below:

I have restored the full backup of the SQL Database onto the Virtual Server SQL Database already using Remote Desktop Connection and SQL Server Management Studio Express, but I am having trouble trying to connect the SQL Database with the site.

I have tried multiple connection strings, and nothing seems to be working. Also, I am 'on my own' with this issue because the GoDaddy.com tech support basically told me this isn't there issue and they can't provide me with any more help!

I have tapped into forums, etc but all I can find is more connection strings to try.

The string I tried to use most recently is this, and it doesn't work:

Provider=sqloledb;Data Source=Server IP,1433;Initial Catalog=SQL Database Name;User Id=USER;Password=PASS;

(I have tested this string in ProductCart's Web Server Readiness Utility)

I think this issue might be bigger than just the connection string though, but this is my first time doing this so what do I know? haha

I've been pulling my hair out about this for over a week now and a solution would be most welcomed.

I understand this is probably not a ProductCart issue, but I am hoping some of you have had this issue in the past and know how to resolve it.

Thanks for the help
-Joe

-------------
Joe S.
BlackReef.net

Replies:

Posted By: Greg Dinger
Date Posted: 09-January-2009 at 11:33pm

Here is a connection string that was used on a site that moved to my servers after they became completely fed up with godaddy and their rigid policies and useless support dweebs.

private const scDSN="Provider=sqloledb;Data Source=p3swhsql-v05.shr.phx3.secureserver.net,1433;Initial Catalog=dbname;User Id=dbusername;Password=passwordhere;"

Needless to say, the server name probably will be different, so you have to work that out on your own, but this at least gives you a pattern to work from.

Friends don't let friends host at Godaddy.

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

Certified ProductCart Developer

Web Design/Development/Hosting

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

Posted By: BlackReefDesigns
Date Posted: 09-January-2009 at 11:46pm

Ya I tried to reply to your PM but it wouldn't let me...

But let me say that I have learned the hard way that GoDaddy.com is horrible - from their tech support to their servers. I wish I hadn't gone with them, but now I am in too deep since my customer had purchased a year plan of Virtual Dedicated server

I will utilize different hosting companies in the future..

Thanks for the hosting string BTW, but it doesn't seem to be working. However I used my IP address for the Data Source - would that work? I notice you have something different in that field

-------------
Joe S.
BlackReef.net

Posted By: Greg Dinger
Date Posted: 10-January-2009 at 9:00am

I have a server guy to whom I can introduce you to. I will PM that information to you.

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

Certified ProductCart Developer

Web Design/Development/Hosting

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