'ROW_NUMBER' is not a recognized function name.
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=26198
Printed Date: 28 March 2026 at 2:21pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: 'ROW_NUMBER' is not a recognized function name.
Posted By: waynehultum
Subject: 'ROW_NUMBER' is not a recognized function name.
Date Posted: 01 September 2008 at 3:11pm
|
Hi,
Ive just installed the forum but i get a errors when I try to do certain things:
When I try to view the active topis I get the following error:
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_active_topics File Name:- active_topics.asp Error details:- Microsoft OLE DB Provider for SQL Server 'ROW_NUMBER' is not a recognized function name. ------------------------------------------------------------------------------------
When I try to view the forum topics I get the following error:
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. Would someone be able to help me with this error?
Kind regards
Wayne.
|
Replies:
Posted By: 123Simples
Date Posted: 01 September 2008 at 6:37pm
|
Hiya You have done what I did and installed the wrong version  You probably needed version SQL Server 2000 version  and maybe Bruce needs to verify that there is a big difference between the two versions of software inasmuch as one cannot be run unless your host has that capability built in ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: WebWiz-Bruce
Date Posted: 01 September 2008 at 7:21pm
|
There isn't many other ways to put it on the download page. You need to download the database version for the type and version of database that you are using. Quite a number of web hosts unfortunately still run SQL Server 2000 which is no where near as good as SQL Server 2005 or 2008. The performance difference with Web Wiz Forums is massive with the SQL Server 2005/2008 version as it can easily cope with forums with millions of posts, compared with the SQL Server 2000 version which is limited to showing the first 5000 Topics only on larger forums. If your web host doesn't give you SQL Server 2005 or 2008 then our own web hosting from Web Wiz does includes SQL Server 2005 databases from as little as $7 per month, with Web Wiz Forums Premium Edition included, installed, and updated for free. For more info see http://www.webwiz.net/webhosting - www.webwiz.net/webhosting We should also be offering SQL Server 2008 in the next couple of months as we have just received the media kits from Microsoft who released it only last month and we are presently putting it through it's paces in our lab. ------------- 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: waynehultum
Date Posted: 02 September 2008 at 9:51am
|
Thanks guys, I'll try installing the SQL server 2000 version.
What we are doing at the minute is developing the forum on our local development server which has SQL server 2000 installed. But our hosts have SQL srver 2005 installed. Do you know if this would cause any issues when we make the forum live?
Regards
Wayne.
|
Posted By: WebWiz-Bruce
Date Posted: 02 September 2008 at 11:01am
|
No it won't do. All you need to do on the live one on SQL Server 2005 is enabling the paging variable to true in the database/database_connection.asp file to improve the performance. You may want to also look at download the free SQL Server 2005 Express for testing on your local development 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: waynehultum
Date Posted: 02 September 2008 at 11:04am
|
Thanks for your help. I installed the SQL server 2000 version and the forum works now.
I'll have a look at installing SQL Server 2005 Express on our dev server.
Thanks again
Wayne.
|