Report on data from your Database using the XSLT Data View web part
-
Retrieve data from your database directly into SharePoint using the XSLT Data View web part in SharePoint Designer. It is shown how to do just that. In addition, you will learn how you can create a parent-child relationship between data from the database and data in a SharePoint list using web part connections.
View 
Subscribe via 
6 Comments
Leave a CommentLeave a Comment
January 29, 2010 pm31 12:23 am
when inserting data view from data source, always get the uninformative error message: “The server returned a non-specific error when trying to get data from the data source. Check the format and content of your query and try again. If the problem persists, contact the server administrator.”
any idea what could be wrong?
January 29, 2010 pm31 12:37 am
yes, I have seen this error before. It’s usually because the data connection is not returning data that can be rendered in the Data View. Ping me offline, asif@sharepointelearning, and let me know what data are you trying to connect to.
March 14, 2011 pm31 11:10 pm
Hi Asif
I have the same problem. Can you post your solution for the problem?
March 14, 2011 pm31 11:54 pm
This is not a bug, it’s by design
. DVWP can’t understand the parent schema that the AW database uses (ex: product.department) so it needs to be converted to be owned by dbo (ex: dbo.department).
There is a script to do that. It’s called AlterSchemaToDbo.sql. Search for it and run it on the database to ‘fix’ this issue.
March 15, 2011 pm31 12:55 am
Thank you so much. It does help to resolve the problem. Would you be so kind to share your wisdom on how you find out it was the database schema problem?
Great video, I will encourage more people to subscribe your site to support your excellent work.
March 15, 2011 pm31 11:37 am
This epiphany happened a long time ago in my head… I can’t recall how anymore.
Enjoy the videos!