WSS 3.0 unable to use datasheet when creating data view in SPD RRS feed

  • Question

  • I created a data view connection in SPD 2007 to a SQL server database to pull data into a datasheet in a web part. We have SharePoint 2007 WSS 3.0. I was able to create the data sheet yesterday, but the data sheet would not update from the SQL database when we selected refresh from within the datasheet. I went back today to work on this problem and now whenever I pull the data view connection onto a web part, it only displays in a list form. The datasheet form is preferred since we can leverage other Office tools for presentation. We are not 64 bit Office.
    Thursday, February 28, 2013 7:53 PM