?
Solved

Using Sharepoint Site to input/read data to SQL database

Posted on 2011-02-17
4
Medium Priority
?
487 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 

Assisted Solution

by:wheelertim
wheelertim earned 500 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 500 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
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…
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…

777 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