http://www.endusersharepoint.com/STP/ SharePoint QA en Wed, 20 May 2009 13:01:42 +0000 http://www.endusersharepoint.com/STP/topic/wss-30-038-sql-database#post-6711 Fri, 15 May 2009 11:33:32 +0000 Greg.Osimowicz 6711@http://www.endusersharepoint.com/STP/ <p>Sharepoint designer allows you to connect to SQL or other OLE DB-compliant data sources. The MS article Add a database as a data source article (http://office.microsoft.com/en-us/sharepointdesigner/HA101009081033.aspx) should point you in the right direction. Build a datasource, use it with data view web part and you should be good to go. </p> <p>Regards,<br /> Greg Osimowicz<br /> <a href="http://Sharepointapplied.com" rel="nofollow">http://Sharepointapplied.com</a> </p> http://www.endusersharepoint.com/STP/topic/wss-30-038-sql-database#post-6707 Fri, 15 May 2009 09:25:03 +0000 erugalatha 6707@http://www.endusersharepoint.com/STP/ <p>aww ... you get my hopes up and dash them in one-fell-swoop. :P </p> http://www.endusersharepoint.com/STP/topic/wss-30-038-sql-database#post-6660 Thu, 14 May 2009 11:08:55 +0000 pagalvin 6660@http://www.endusersharepoint.com/STP/ <p>Darn, I did. I can't find the link now... sorry! </p> http://www.endusersharepoint.com/STP/topic/wss-30-038-sql-database#post-6657 Thu, 14 May 2009 09:44:19 +0000 erugalatha 6657@http://www.endusersharepoint.com/STP/ <p>Hi Paul,</p> <p>Did you mean to post a link there? </p> http://www.endusersharepoint.com/STP/topic/wss-30-038-sql-database#post-6624 Wed, 13 May 2009 15:21:53 +0000 pagalvin 6624@http://www.endusersharepoint.com/STP/ <p>You should also be able to use data view web part for this.</p> <p>This article seems to show a good approach (you have to slog through a lot in the front to get to the good part). </p> http://www.endusersharepoint.com/STP/topic/wss-30-038-sql-database#post-6610 Wed, 13 May 2009 12:37:12 +0000 Eric Truchon 6610@http://www.endusersharepoint.com/STP/ <p>Hi,</p> <p>You can use PowerShell to fill your WSS List, but you will need to develop some scripts and create a Windows task calling your scripts every x times.</p> <p>SQL retrieve data exemple : <a href="http://www.leeholmes.com/blog/InteractingWithSQLDatabasesInPowerShellInvokeSqlCommand.aspx" rel="nofollow">http://www.leeholmes.com/blog/InteractingWithSQLDatabasesInPowerShellInvokeSqlCommand.aspx</a></p> <p>WSS Add item to a list :<br /> <a href="http://blogs.flexnetconsult.co.uk/colinbyrne/2008/02/26/PowerShellSharePointAddAListItem.aspx" rel="nofollow">http://blogs.flexnetconsult.co.uk/colinbyrne/2008/02/26/PowerShellSharePointAddAListItem.aspx</a></p> <p>Eric </p> http://www.endusersharepoint.com/STP/topic/wss-30-038-sql-database#post-6609 Wed, 13 May 2009 12:04:53 +0000 erugalatha 6609@http://www.endusersharepoint.com/STP/ <p>Hi,</p> <p>In MOSS Enterprise we have BDC to allow us to look out to external datasources from lists. </p> <p>Is there anything available for WSS 3.0 to allow me to expose data from a SQL Database in a SharePoint List? </p>