Data View List Error

V

victoriap

I have created a new dataview using data from a SQL database. It is a
simple list of technical support queries.

Everything works fine - I save the page and look at the page through
SharePoint and it lists the first 10 records correctly. As soon as I
use any other function - either Next 10 records, filter, group etc
which queries the database again - I get an error message
"An error occurred while processing the data for this request. Contact
the server administrator for more information"

Which is next to useless!

Note: SharePoint and the SQL database are on different servers.

Any ideas anyone?
 
Top