Web Wiz Forums - New install- SQL Dbase issue

Print Page | Close Window

New install- SQL Dbase issue

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=27638
Printed Date: 28 March 2026 at 1:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: New install- SQL Dbase issue

Posted By: Dono
Subject: New install- SQL Dbase issue
Date Posted: 28 July 2009 at 10:40pm

Hello,

I just installed WebWiz with sql server.

I created the dbase, installed the webwiz forum, and tested dbase. Test was sucessful.

Now, I created forums, and then subforums.

When I enter a subforum to post, I see this 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.

I am sure I missed something in setup. Shouldn't I be doing something to prep the dbase I created on the sql server?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 29 July 2009 at 10:33am

DBase is not supported by Web Wiz Forums. You need to use SQL Server, mySQL or Access.

ROW_NUMBER is only supported by SQL Server 2005 or 2008. If you are using SQL Server 2000 then when you install Web Wiz Forums you need to select SQL Server 2000 from the list and not SQL Server 2005.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: Dono
Date Posted: 29 July 2009 at 2:44pm

Thank you!

Im am using Server 2003, but couldn't remember which version of SQL.

Software looks excellent so far.