'ROW_NUMBER' is not a recognized function name.

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
waynehultum Members Profile Find Members Posts Newbie Joined: 01 August 2007 Status: Offline Points: 6	Post Options Post Reply Quote waynehultum Report Post Thanks(0) Quote Reply Topic: 'ROW_NUMBER' is not a recognized function name. 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.

123Simples Members Profile Find Members Posts Senior Member Joined: 08 July 2007 Location: United Kingdom Status: Offline Points: 1192	Post Options Post Reply Quote 123Simples Report Post Thanks(0) Quote Reply 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
	Visit 123 Simples Web Design

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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 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. Edited by WebWiz-Bruce - 01 September 2008 at 7:27pm
	Web Wiz Forums Hosting ASP.NET Web Hosting

waynehultum Members Profile Find Members Posts Newbie Joined: 01 August 2007 Status: Offline Points: 6	Post Options Post Reply Quote waynehultum Report Post Thanks(0) Quote Reply 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.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

waynehultum Members Profile Find Members Posts Newbie Joined: 01 August 2007 Status: Offline Points: 6	Post Options Post Reply Quote waynehultum Report Post Thanks(0) Quote Reply 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.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum