Server Error in Forum Application
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25012
Printed Date: 28 March 2026 at 7:54am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Server Error in Forum Application
Posted By: jp05
Subject: Server Error in Forum Application
Date 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! |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 14 December 2007 at 3:17pm
|
GoDaddy doesn't support Web Wiz Forums, you would need to look for a host that does.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: jp05
Date 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. |
Posted By: WebWiz-Bruce
Date Posted: 14 December 2007 at 3:42pm
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 http://www.webwiz.net/webwizforums/kb/non_supported_webhosts.asp - Unsupported Web Hosts ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
-boRg- wrote:Posted By: jp05
Date 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? |
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: jp05
Date 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. |
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: jp05
Date Posted: 14 December 2007 at 5:10pm
|
I need to back track a wee bit. I had nothing to do with the creation of this site. I'm just trying to facilitate getting it up and running with a new host. I had originally assumed the database was hosted at the same place the site resided. I spoke with that provider, and he told me that was not the case. So, I was then under the assumption that your company was housing that... now I'm thinking that might be incorrect... I'm not a programmer-type, so this is all a little out of my realm of expertise... How do I find the stinkin' database?? ("ask the client" would seem like an obvious answer to that, but I can all but guarantee that that will get me nowhere.) thanks! |
Posted By: jp05
Date Posted: 14 December 2007 at 5:22pm
| for the record, the GoDaddy issue is settled. I'll suggest a different host. |
Posted By: WebWiz-Bruce
Date Posted: 14 December 2007 at 5:33pm
|
You can look in the database connection file. This should give you a good idea. The file is at database/database_connection.asp and in this file you should find the SQL Server connection, hopefully it would be a URL such as sql.webhost.com if it's an IP address it maybe a bit more difficult to track down, but can be done. However, SQL Server is not a file that you download, you would need to use tools to migrate the database from the previous host, which isn't always simple as newer tools in Microsofts Management Studio for SQL Server don't like to transfer default values and indexes. The last SQL Server database I transferred took over 3 hours to get it across from SQL Server 2000 to our own SQL Server 2005, but managed it in the end. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: jp05
Date Posted: 14 December 2007 at 5:46pm
| Very helpful. Sounds like I'll have to bring in someone with a bit more experience with this sort of thing. Have a wonderful evening. |
Posted By: WebWiz-Bruce
Date Posted: 14 December 2007 at 6:58pm
|
If you can track down where the SQL Server database is, you hopefully should be able to ask the provider for a backup of the database, this can then be used by your new host to restore the database on their servers. It takes a bit of co-operation from both providers, but may make it simpler if you can get them both to play ball. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |