Hot answers tagged sharepoint-designer
Another option that you can look into is the Business Data Catalog. While this is more complicated it does allow you to have a SharePoint view of the data. The downside to this is that it does require the Enterprise edition and pretty advanced skills to get the BDC configured to point to your custom database. Since you said you are not a developer, I would ...
I don't know how to do it using SharePoint Designer, but here's how you can do it in a browser: navigate to the Title, Description, and Icon page (Site Actions > Site Settings > Title, description, and icon), enter address of the logo in the URL field.
It looks like you are getting an error when the SQL command is executed against the database. (OracleCommand.Execute) is the eror line. The error says that it does not expect the "from" statement in your "select * from" I would suspect there is some extra string data in the command string being passed.
I took some time investigating this. In SP 2010 it is easy to import a table as an EXTERNAL SharePoint list. The data in the db and the list and is syncronized dynamically when someone modifies the table in the DB or the List in SP. But trying to create a workflow that writes data to and external SharePoint list...well you can do it but it involves a ...
I would think you could: Create an Excel spreadsheet that has the SQL query to the database Execute the query and do a Copy Values copy in Excel and paste that to a new workbook Import that workbook when creating the Sharepoint list For displaying data live using a query, you need the Sharepoint Designer and you add a Data View to the list. See: ...
Only top voted, non community-wiki answers of a minimum length are eligible