Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How to link a sql table into WSS list?

  Asked By: Chelsea    Date: Sep 02    Category: Sharepoint    Views: 2636

I need to link a table which is in different SQL Server and in different database into Sharepoint List. What are the steps to perform this task?

I have table of user contacts into SQL Server database in one application and now we are creating WSS site for that application, both DB Servers and Databases are different and I am using WSS 2003 and SQL Server 2000.

Is Web Part only the solution for that task ?



4 Answers Found

Answer #1    Answered By: Willard Valenzuela     Answered On: Sep 02

When you view a list  in WSS, you are using a web part to view it. If you need
view-only access to the database, you could use a data view web part. If you
need it to be updateable, similar to a WSS list, you could create a web part
with an updateable datagrid-style interface. Do you need to keep the data in
SQL Server, or could you import it into WSS and manage it from there?

Answer #2    Answered By: Damon Garner     Answered On: Sep 02

I want to keep the information into SQL Server as the information is being updated from other application  in other database. I think data view web part solution is fine for me here in this situation, could you please write me steps  to use that data view web part to achieve that task,I have not done any custmazation yet in SPS.

Answer #3    Answered By: Emmett Hyde     Answered On: Sep 02

If you Google "data view web part" you will find all kinds of information to
help you. My one suggestion is to create a new web part page before opening
your site  in FrontPage. Create the DVWP on this page, and then you can export
it for use wherever you want. This keeps you from unghosting other pages in
your sites unnecessarily. For an explanation of "ghosted" pages in WSS, check
out Ted Pattison's explanation here http://tedpattison.net/UsingFPwithSP.aspx.

Answer #4    Answered By: Michelle White     Answered On: Sep 02

I have a question similar to this. Can you upload an run Access database  that require backend connections on WSS?

Didn't find what you were looking for? Find more on How to link a sql table into WSS list? Or get search suggestion and latest updates.