Having problem with a clean install of Able Commerce

[John Gaby]

I have installed a clean copy of able commerce (7.0.2 build 11659) and when I click on the "Sample Category" link on the home page, I get the following excption on line 261 of CategoryGridPage.ascx.cs:

"The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator."

I have made NO changes to the site.

Does anyone have any idea what is going on? We are using a SQL 2000 server if that matters.

Thanks

[John Gaby]

As an update, if I switch to using SQLEXPRESS 2005, then it seems to work. Is Able Commerce not compatible with SQL 2000?

[John Gaby]

Ok, so if I start with a clean install of Able into SQLEXPRESS 2005, it works. However if I copy my existing SQL 2000 Able database to the 2005 server, I get the same error as described above. Is there a to fix this problem?

[John Gaby]

For what it is worth, I found the patch that fixes this problem.