Solved

Using Sharepoint Site to input/read data to SQL database

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
These days socially coordinated efforts have turned into a critical requirement for enterprises.
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…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

770 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