tags:

views:

39

answers:

2
Q: 

Paged has a error when database is SqlServer 2000

var products = Product.GetPaged(1, 20);

error:

'ROW_NUMBER' ....

+3  A: 

I don't think Subsonic supports paging for SQL Server 2000 (but I could be wrong). You'd need SQL Server 2005 or 2008.

Philippe Leybaert  2009-07-24 08:32:18
+3  A: 

I'm guessing Subsonic uses a CTE or the ROWNUMBER() syntax. These are not supported in SQL2000

John Nolan  2009-07-24 08:34:50

related questions

Subsonic 3 Active Record Testing
Is there any demo to insert a new record into a table with identity primary key using Subsonic 3?
Subsonic SimpleRepository problem with Category.All
Problem with RunMigrations in SimpleRepository Example - Subsonic 3
Subsonic 3, MySQL T4 template: Structs.tt fails
SubSonic 3 ActiveRecord generated code with warnings
subsonic 3 scaffolding
Subsonic 3.0 SP parameter error
SQL Views in SubSonic 3.0
Defining SubSonic 3 ActiveRecord migrations
Is my IQueryable syntax correct?
Subsonic 3 Union Possible?
Create Foreign Key to ASP.Net Roles table
Does Subsonic 3 ActiveRecord Handle Many To Many Relationships?
Is there a way to generically return all of the records from a table with the Entity Framework
Is Subsonic 3.0 safe for production use?
Subsonic 3 SVN Checkout and T4
Subsonic 3/ASP.net MVC issue trying to override class column properties
NULL ForeignKeyTo property in Subsonic 3/ASP.NET MVC?
Subsonic 3/ASP.net mvc trying to save a null value in a datetime column
Which SubSonic 3 template to use
Subsonic 3 State
Subsonic3 & GUIDs
Subsonic 3 - Namespace hidden - Probably me!
Inserting a new record pattern in SubSonic 3