Print Page | Close Window

'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 Cry
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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net