Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Sharepoint 2.0 dataview web part only displays first page

  Asked By: Charmaine    Date: Apr 14    Category: Sharepoint    Views: 1766

I have an SBS2003 premium installation that is current with all SP's and
updates. I have created some pages in both frontpage2003 and spd2007 using
the dataview component with a data connection to a sql2005 database. I find
that when the page is displayed in the browser, only the initial page of data
can be returned. The 'Next' link always results in the message "An error
occurred while processing the data for this request. Contact the server
administrator for more information."
I have also found that the problem only occurs with new(er) databases, the
example Northwind db works fine, older sharepoint and sbsmonitoring db's work
fine. ISA2004 firewall db's which are current exhibit the error as do any
current manually created databases (regardless of how simple they are). I
EXPORTED the Northwind db into a new db and still have the problem; a
duplicate made with the COPY DATABASE operation works properly.
There are no problems creating any data sources or accessing them, only the
paging aspect of the dataview web part is a problem.
I attached a db created using SQL 2005 Express and the problem is still
evident. The db was created by the same program which created the original db
that led to the discovery of this problem, so the procedure generating the
db's is identical. The SQL Express edition is on a stand-alone system
separate from this location and domain.
The AdventureWorksLT database (dated 12/2006) works fine. However, I added a
new table to it manually, and while the original tables were unaffected, the
newly created table exhibited the same incompatibility problem with the
dataview web part as newer databases.
Any ideas would be appreciated as this has brought a major project on this
system to a dead stop.



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Sharepoint 2.0 dataview web part only displays first page Or get search suggestion and latest updates.