Solved

Using Sharepoint Site to input/read data to SQL database

Posted on 2011-02-17
4
472 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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

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.
This is about my first experience with programming Arduino.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

759 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now