New SQL Installation
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=27844
Printed Date: 28 March 2026 at 1:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: New SQL Installation
Posted By: Agni
Subject: New SQL Installation
Date Posted: 17 September 2009 at 9:49am
New Installation seems to be fine (I can edit forum settings and have added some text forums) but when viewing any forum I get the following message:
Server Error in Forum Application
An error has occurred while executing SQL query on database.
Please contact the forum administrator.
Support Error Code:- err_SQLServer_get_topics_data
File Name:- forum_topics.asp
Error details:-
Microsoft OLE DB Provider for SQL Server
'ROW_NUMBER' is not a recognized function name.
Forum Location: http://www.agni.gr/reservations/
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 17 September 2009 at 12:47pm
The error means that you have installed the SQL Server 2005/2008 version when you are using SQL Server 2000.
Re-upload the original files again, but as you have now crated the database when the setup wizard runs select a 9.x upgrade option and this time for the database select SQL Server 2008.
-------------
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: Agni
Date Posted: 17 September 2009 at 2:52pm
Excellent, thank you Bruce.
Should I be asking my host to upgrade to 2005/08 SQL versions then?
-------------
www.agni.gr
Travel To Greece Guide
|
Posted By: WebWiz-Bruce
Date Posted: 18 September 2009 at 9:25am
Using SQL Server 2005 or SQL Server 2008 will give much better performance due to server side paging.
However if your web host is yet to upgrade I doubt they will as upgrading SQL Server is a huge deployment. They may though have other database servers running SQL Server 2005 or 2008 that you can move to.
-------------
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: Agni
Date Posted: 18 September 2009 at 12:17pm
Thanks Bruce.
-------------
www.agni.gr
Travel To Greece Guide
|
|