Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 829
  • Last Modified:

SharePoint 2010 front end for SQL Server Database

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
CooperRiis
Asked:
CooperRiis
  • 2
1 Solution
 
CooperRiisAuthor Commented:
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
 
Clay FoxDirector of Business IntegrationCommented:
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
 
CooperRiisAuthor Commented:
This product does exactly what I am looking for with little to no coding.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now