Using Sharepoint Site to input/read data to SQL database
Posted on 2011-02-17
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.