Solved

SharePoint 2010 front end for SQL Server Database

Posted on 2013-05-25
3
774 Views
Last Modified: 2013-05-27
Mission:

I am creating a full application platform for all departments in my organization to interact with my database through the use of SharePoint external content types and InfoPath forms.

Problem:

I am unable to create the correct forms without using features that are outside the realm of browser enabled forms.

I need to have multiple connections to the database to populate dropdown options.

When I create the form I'm able to quick publish the form with the warning that it must to completed in InfoPath Form Filler. (This would be fine because my users all have InfoPath installed with Office.) However I'm unable to have the default New Item and Edit Item buttons on my external content list open the Form Filler. Instead they simply give an error that the form is not browser compatible.

Question:

How can I force the list to open the form filler in the same way a form library would?
 Or How can I create a form library that can update to my external content type?
Or Is there a simpler way to complete this task with little to no knowledge of any programing language?

Or At the very least can someone tell me that what I'm attempting is impossible and I need to back up and design a full platform myself and then point me toward some articles or books that could help me to build a platform for my users to use to interact with my database that is web accessible and secure?
0
Comment
Question by:CooperRiis
  • 2
3 Comments
 

Author Comment

by:CooperRiis
ID: 39196783
Did I mention that my supervisors are requiring this task to be completed yesterday with little to no knowledge of the work involved in completing the project they have hap-hazardly decided is within my realm of expertise because I simply have the title of IT technician.
0
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
ID: 39196821
I have been there.
Best practice is web services to move the data between your forms and the DB with the greatest ease and functionality.
if this is going to be an enterprise platform, which I think is great, I would look at www.qdabra.com and their package of web services and SP integration.  It will get you the missing component you need with just and install and a little ramp up.

hope that helps.
0
 

Author Closing Comment

by:CooperRiis
ID: 39199012
This product does exactly what I am looking for with little to no coding.
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

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

803 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