Solved

Using Sharepoint Site to input/read data to SQL database

Posted on 2011-02-17
4
481 Views
Last Modified: 2012-06-22
Hello all-

I'm fairly new to sharepoint and am considering implementing a solution that would consist of a few forms. One form that inputs data to a SQL database and one or two forms that read records from the database. I already have a functional sharepoint 2003 site and SQL 2005 database setup.  I'd like to have the ability for multiple user's to hit the same form at once.   My main question is what method I should use to create the input/ouput forms? Should I use a web part on the sharepoint site?  I have infopath installed on my machine, but none of the other users have infopath so I don't think using infopath is the right way to go.  I'm open to developing something as I have a development background.  Please let me know what you think is the best way to go about this.

Thanks!
0
Comment
Question by:dgmsg
4 Comments
 

Assisted Solution

by:wheelertim
wheelertim earned 125 total points
ID: 34923154
I would suggest using either application pages or webparts to do this depending on the scope, webparts would be the simplest rout
0
 
LVL 14

Accepted Solution

by:
KoenVosters earned 125 total points
ID: 34924398
Upgrade to SharePoint 2010 and make use of the Business Connectivity Services.
Sharepoint 2003 is no longer supported by Microsoft by the way :-|
http://support.microsoft.com/lifecycle/?p1=2528
0
 
LVL 53

Expert Comment

by:Dhaest
ID: 35321627
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question