Connection Problems
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=27326
Printed Date: 02 April 2026 at 7:08pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Connection Problems
Posted By: j172
Subject: Connection Problems
Date Posted: 04 May 2009 at 4:55pm
Hi,
I have a problem with my forum, my host has recently upgraded to sql
2008 from 2005. With 2005 it was working fine but since the upgrade i
get the error:
Server Error in Forum Application
An error has occurred 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
[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.
I tried a complete new install with a fresh database but get the error:
Detailed Error Message:
[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.
Error Details:
[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.
I have upgraded to the lastest version of webwiz forums with a clean install but still no luck. Is there something i need to do?
Many Thanks
Joel
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 04 May 2009 at 5:03pm
There is no issue with Web Wiz Forums using SQL Server 2008. We use SQL Server 2008 for all our hosted solutions now without any problems.
You should contact your web host about this issue. tell them since the upgrade you can no-longer use a TCP/IP connection to the SQL Server using ASP. They may have changed the configuration settings or a miss configuration setting on the server.
-------------
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: j172
Date Posted: 05 May 2009 at 7:08pm
I have asked my host and they have now sorted the problem. The solution was to add the port number in the server name in the database_connection.asp file
i.e.
strSQLServerName = "sql01,1433"
Hope this helps anyone in the future
|
|