Solved

SharePoint 2010 front end for SQL Server Database

Posted on 2013-05-25
3
766 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

914 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now