Web Wiz Forums - SQL 2000 to SQL 2008

Print Page | Close Window

SQL 2000 to SQL 2008

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=28948
Printed Date: 01 April 2026 at 4:04pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL 2000 to SQL 2008

Posted By: Jagoop
Subject: SQL 2000 to SQL 2008
Date Posted: 06 November 2010 at 9:59am

After migrating our forum for an SQL2000 base til SQL2008, I'vetried to enable Advanced Paging.

But when I change "blnSqlSvrAdvPaging" from false to true in database_settings.asp, I 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_topic_posts_data
File Name:- forum_posts.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
No column name was specified for column 22 of 'PagingQuery'.

Is there something else I should be doing?

Replies:

Posted By: 123Simples
Date Posted: 06 November 2010 at 1:38pm

I assume that when it was left at false you had no errors on the forum?
It was only when you changed the value to true that this happened?

-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design

Posted By: Jagoop
Date Posted: 10 January 2011 at 9:59pm

Correct

Posted By: WebWiz-Bruce
Date Posted: 11 January 2011 at 9:13am

Check that the database is not still running in SQL Server 2000 compatibility mode. If it is change it to SQL Server 2008.

You should be able to do this through the SQL Server Studio Manager by righting clicking the database, selecting Properties, then under the Options tab you will find the Compatibility level for your database.

-------------
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