ProductCart Shopping Cart Software Forums : Having issues trying to connect database to site

ProductCart Shopping Cart Software Forums : Having issues trying to connect database to site https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 04:10:26 +0000 Sat, 10 Jan 2009 09:00:33 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=2329 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Having issues trying to connect database to site : I have a server guy to whomI can...]]> https://forum.productcart.com/having-issues-trying-to-connect-database-to-site_topic2329_post8239.html#8239 Author: Greg Dinger
Subject: 2329
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.]]> Sat, 10 Jan 2009 09:00:33 +0000 https://forum.productcart.com/having-issues-trying-to-connect-database-to-site_topic2329_post8239.html#8239 <![CDATA[Having issues trying to connect database to site : Ya I tried to reply to your PM...]]> https://forum.productcart.com/having-issues-trying-to-connect-database-to-site_topic2329_post8236.html#8236 Author: BlackReefDesigns
Subject: 2329
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 ishorrible - from their tech support to their servers. I wish I hadn'tgone with them, but now I am in too deep since my customer hadpurchased 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
]]> Fri, 09 Jan 2009 23:46:25 +0000 https://forum.productcart.com/having-issues-trying-to-connect-database-to-site_topic2329_post8236.html#8236 <![CDATA[Having issues trying to connect database to site : Here is a connection string that...]]> https://forum.productcart.com/having-issues-trying-to-connect-database-to-site_topic2329_post8235.html#8235 Author: Greg Dinger
Subject: 2329
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.

]]> Fri, 09 Jan 2009 23:33:23 +0000 https://forum.productcart.com/having-issues-trying-to-connect-database-to-site_topic2329_post8235.html#8235 <![CDATA[Having issues trying to connect database to site : Hello -We are trying to move...]]> https://forum.productcart.com/having-issues-trying-to-connect-database-to-site_topic2329_post8234.html#8234 Author: BlackReefDesigns
Subject: 2329
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

Edited by BlackReefDesigns - 09-January-2009 at 10:20pm]]> Fri, 09 Jan 2009 22:19:03 +0000 https://forum.productcart.com/having-issues-trying-to-connect-database-to-site_topic2329_post8234.html#8234