Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SharePoint 2010 front end for SQL Server Database

Posted on 2013-05-25
3
Medium Priority
?
828 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:
Clay Fox earned 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

580 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