Solved

Using Sharepoint Site to input/read data to SQL database

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
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 …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

910 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

22 Experts available now in Live!

Get 1:1 Help Now