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.
This video is part of the SharePoint Designer 2010 video tutorials DVD
Course: SP201 – SharePoint Designer 2010: Create No-Code Solutions
Members Only
Please log in in the pane to the right, to view this video tutorial.
If you are not a member of the site, please look into subscription options.
Asif Rehmani
Trainer / Consultant / Speaker / Author on all things SharePoint and InfoPath. Asif is a SharePoint Server MVP and MCT who loves the process of transferring his knowledge to others. For a complete Bio of Asif Rehmani, please visit this page: http://www.sharepoint-videos.com/about/
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?
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.
Hi Asif
I have the same problem. Can you post your solution for the problem?
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.
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.
This epiphany happened a long time ago in my head… I can’t recall how anymore.
Enjoy the videos!