| Author |
 Topic Search  Topic Options
|
jp05 
Newbie
Joined: 14 December 2007
Status: Offline
Points: 7
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Server Error in Forum Application
Posted: 14 December 2007 at 3:10pm |
|
I recently moved a working version of the forum to a new host (GoDaddy), and now receive this error on the forum page:
------------------
Server Error in Forum Application
An error has occured while connecting to the database.
Please contact the forum administrator.
Support Error Code:- err_SQLServer_db_connection
File Name:- common.asp
Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid connection string attribute
-----------------
I've seen at least one other post on the same error but the "poster" said it was an intermittent problem, and the response was "if it's intermittent, it is likely a problem with the hosting provider". Mine is not an intermittent issue, I have not yet been able to get the page to display anything but this error.
any feedback is greatly appreciated!
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 December 2007 at 3:17pm |
|
GoDaddy doesn't support Web Wiz Forums, you would need to look for a host that does.
|
|
|
|
jp05
Newbie
Joined: 14 December 2007
Status: Offline
Points: 7
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 December 2007 at 3:41pm |
|
Thanks for the quick response! I spoke with GoDaddy, and they said I could either set up a "virtual dedicated server" (ie: expensive) or I could move the database to their servers (since the plan my client purchased includes 2 databases). Is that a possibility?
Again, many thanks.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 December 2007 at 3:42pm |
 -boRg- wrote:
GoDaddy doesn't support Web Wiz Forums, you would need to look for a host that does.
|
Don't you just love repeating yourself. If your client wishes to use Web Wiz Forums then you would not be able to use GoDaddy. I know people like to use GoDdady because they are cheap, but with web hosting you often get what you pay for. The following page lists Unsupported Web Hosts
Edited by -boRg- - 14 December 2007 at 3:47pm
|
|
|
|
jp05
Newbie
Joined: 14 December 2007
Status: Offline
Points: 7
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 December 2007 at 3:51pm |
|
right, well, I guess what I was saying was that GoDaddy seemed to at least be offering solutions. They said that "for security reasons" they won't link to an external database, but it should work if the database is hosted with them. This is certainly preferable to finding/purchasing a new hosting plan.
Obviously you've run into this issue in the past, I understand. Are you saying I cannot move the database to GoDaddy, or are you suggesting that if I do, it still will not work?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 December 2007 at 4:12pm |
|
This has nothing to do with were the database is located.
The solution I have given to look for another host is a very good solution, a quick search for GoDaddy will show they are one host worth avoiding, and I would highly recommend that you do.
You may well be able to get the software running under GoDaddy, but
most can not, and you would not be able to upgrade. For this reason
they are listed in the unsupported hosts page under the system
requirements for the software, and my advice from 7 years of dealing
with support issues about this host is to save yourself allot of problems
and look for a better host.
Edited by -boRg- - 14 December 2007 at 4:18pm
|
|
|
|
jp05
Newbie
Joined: 14 December 2007
Status: Offline
Points: 7
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 December 2007 at 4:44pm |
|
I completely understand your argument, and trust your expertise in the matter. I certainly agree that you "get what you pay for". My client wanted to use GoDaddy. If I am going to suggest to them that they now need to change hosting again I just want to be able to give them a valid reason. GoDaddy has suggested to me that it IS an issue with where the database is located, and you are saying it is not. They did specifically say that they would not link to an external database.
That being said, my guess is that you are probably correct, since this is obviously a specific issue that you have been dealing with for quite some time. My problem is that GoDaddy seems to be saying something different, thus making it harder for me to give an absolute justification for moving.
Again, I understand you do not want to deal with GoDaddy issues, as they are specifically a hosting provider that you have listed as a "non-supporter", so I appreciate your time in dealing with this.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 December 2007 at 4:54pm |
|
Most web hosts will block connections to external SQL Server databases for security reasons, so this is not the reason why I have said to not use GoDaddy.
Also connecting to SQL Server on another network to that of your web host is not recommend, as usually data flows allot more slowly across the internet and response times are much lower, which generally leads to a very, very, slow loading forum.
Ideally you need to have both the web site and the SQL Server with the same provider.
One of the issues with GoDaddy is they route outbound TCP port 80 connections through proxy servers, this means that parts of Web Wiz Forums that use XML over TCP Port 80 will not work. You also will not be able to connect to the license server to register the software, which works the same way as PayPal's IPN service which is something else which doesn't work on GoDdady when using ASP.
|
|
|
|
