.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Urgent: InfoPath Forms on SharePoint and SQL Server

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :SharePoint
 
Hello,

I'm very new to using InfoPath but we recently upgraded to SharePoint Enterprise 2010 and we would really like to take advantage of the new InfoPath Form Services that's available with this version of SharePoint. I need to know if it's possible to build a form that gets data from a Microsoft SQL Server, and also when that form is submitted it will need to populate a table on our Microsoft SQL Server. This form will also need to be published on SharePoint so our users can fill out the form directly from there. Is this possible? I've been trying to figure this out for almost a week now and can't seem to get very far at all- it's very frustrating.

If it is, what would be the first steps that I need to take? I thought it was as simple as building a form in InfoPath2010 and just publishing it to SharePoint but I get the feeling that I need to upload some type of data connections to SharePoint Central Administration?



View Complete Post


More Related Resource Links

Cannot publish InfoPath 2010 form template to SharePoint Server 2010 RC

  
Hi all, I am MSFT in Vietnam. I created a SharePoint list using InfoPath 2010 RTM 64bit. After publishing it to SharePoint 2010 RC, I see an error message:  Click on button "Show Details" the message is The list schema does not match the schema of this form. Refresh the data source and publish the form again. When I create new item based on published SharePoint list, I can see plain form not browser enabled InfoPath form. I checked InfoPath Form Services, everything seems to be good. What should I do to publish SharePoint list from InfoPath 2010 to SharePoint 2010 as browser enabled form?

Getting error while retrieving data from sql server 2008 to infopath 2007 in sharepoint 2007

  
Hi, I have created an InfoPath form in InfoPath 2007. In this form I am getting data from SQL Server. To do this I have created data source for SQL Server 2008’s Tables. I have created 4 connections for 4 tables. When I am previewing this form from InfoPath Designer 2007, it is working. But when I am publishing this, it is giving me an error ‘Can not update content type’. If I skip this error then my form published but when I open this form from Share Point 2007. It gives me an error:   There has been an error while processing the form. Click Continue to resume filling out the form. You may want to check your form data for errors. Click Start Over to load a new copy of the form.   An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID: 6932 G. Goyal

Sharepoint 2010 workflow using asp.net forms and or infopath forms

  
Hi, Does anyone know of any good step by step articles on a state machine workflow with ASP.NET forms and or inforpath forms ? Ive created a blog on a generic workflows but want to learn more about the forms side of things - any pointers would be great. Paul.   PS here is my how to guide : http://sp2010site.blogspot.com/2010/09/how-to-create-and-debug-state-machine.html  

Sharepoint 2010 workflow using asp.net forms and or infopath forms

  
Hi, Does anyone know of any good step by step articles on a state machine workflow with ASP.NET forms and or inforpath forms ? Ive created a blog on a generic workflows but want to learn more about the forms side of things - any pointers would be great. Paul.   PS here is my how to guide : http://sp2010site.blogspot.com/2010/09/how-to-create-and-debug-state-machine.html  

import data from infopath xml forms to SharePoint list

  
Hi. I have this issue, a customer has an old application that consists of a SharePoint 2003 site and a 'forms library' with forms listing information about physical servers. The infopath (2003) form is pretty straight forward and has a few dropdowns from lists and so on. Now, we need to move this to 2010 and preferably to a list only using oob functionality. I would like to know if anyone has a clue as to how I can get the data from the hundreds of xml files into a list, could be to excel and then to SharePoint, or any means Necessary. I would prefer it if it can be scripted or done using standard tools from Microsoft, no 3rd party custom xml importer...(if it's not really good and free :-) ) ThanksThomas BalkestÃ¥hl - Technical Specialist - SharePoint

Sharepoint 2010: Browser compatible infopath forms are not open in web browser for editing

  

I created a browser enabled form with InfoPath 2010. I then published the form by selecting the option "Publish form to a SharePoint library" and then selected "Form library" and finally selected "Create a new form library". As a result, a new form library was created.When I click on "add document", the browser opens a new form, which I can fill and save successfully. However, after the form is saved, whenever I click on the form name in the form library to edit it, the browser "opens with" dialog box opens, asking for an XML editor software. In other words, the form does not open in browser for editing even on systems that do not have InfoPath installed.

The form is browser compatible and the form library is configured to open browser-enabled forms in browser. The issue is that the form hyperlink is directly pointing to form XML file rather than pointing to InfoPath form services URL.

I would really appreciate, if someone tells me how I can edit the form in browser.

 

 

 


Dynamiq publishing in SharePoint and Deployment of InfoPath Forms Services

  

Actually, i am working in InfoPath Forms services under MOSS2007. I am publishing Infopath in a specific site (http://<serverName>:<serverport>), and after i upload the administrator form in sharePoint and activate it in a site collection.

I want to ask if there is a solution to publish infopath  with code

I have found how to activate infopath in a site collection with code .

thanks for advance.


infopath template on wss2.0 sharepoint site has been deleted - how to open infopath forms?

  

Hi All

Is there any way to open infopath forms (from a sharepoint site) if the template has been removed?

I have a case where infopath forms (xml files) have been saved to a sharepoint site, but the templates (xsn files) have been deleted.

Some users are still able to open the infopath forms and I'm guessing it is because the templates are cached on their workstations.

The problem obviously comes into play when a new user or user with a new workstation tries to open the infopath forms.

Any ideas how these files could be opened?


move infopath forms from SP Portal Server 2003 to 2007

  

I am a newbie to SharePoint. Please let me know if I didn't explain my problem well...

We built the new SharePoint server 2007 on a different physcial box from the old server 2003. There are huge amount of InfoPath forms in form library on the old server. I was told that: to get these forms moved over to the new server 2007, we have to save the forms and re-publish to the new server one at a time. This will be really time consume and also loosing the attributes of the original forms, the date it was created and modified etc.

I would like to see if there is a way to move one form library at a time, and just copy the forms over; not publishing them again.

Many thanks!


mh

cascading drop down list in infopath forms services Using SharePoint Look up list from multiple Sh

  

Hi 

Some one can help me, if possible screen shots.
Environment : MOSS 2007, InfoPath 2007

Sharepoint infopath forms problem / state service

  

Hi,

I am uploading an infopath form to sharepoint.  Infopath reports that the form uploaded successfully, however when I click the link to open the form in the browser, I get a message:

The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service. For more information, contact your server administrator.

I've google about and it appears that setting up the state service and associating it with the application solves the problem.  I've followed the instructions, but the problem still persists!  Do I need to stop/start something else to get it to work?  The service application pages report the service is running and associated with the applications.

Thanks for any help - it's driving me nuts


Browser based InfoPath forms in Sharepoint error

  

Hello,

I have a form that we built in InfoPath2010 and I am trying to publish it to SharePoint2010 using the "broswer-based" capability. The form works in preview mode in InfoPath, but when I publish it to SharePoint, I get the follwing error:

"You do not have permissions to access a database that contains data required for this form to function correctly.
An entry has been added to the Windows event log of the server.

Log ID:5566

Correlation ID:9161ac7c-7b8f-4164-907a-14426c54b24f"
The form has two main data connections, both are tables in a sql database server. They display data from the tables, and the users are also able to input data into the database. The form right now is configured as "full" trust, as we have custom code in the form that will only work with that setting. I have also uploaded the two UDC connection to a data connection library in SharePoint, but no luck.
Here is part of the  the custom code in our form that may be causing issues:
SqlConnection con =

Querying InfoPath forms deployed to a Sharepoint Library

  

Hello all,

We have a form library that stores a form with information for each database we host for our clients. Each database we host has an associated form with information such as:

Database Owner
Application Supported
Backup Location
Security Requirements
And so on...

I was asked to put the form together back a couple months back so we could inventory our databases.

It works, the library now has over 30 forms.

Now I'm being asked to transfer these records from the infopath forms/libray into a database table so we can report from.

I have no clue if I can connect to these forms and pull data from them, do you guys know?

I would like to loop through this library and pull the data from each form into a SQL table, is this doable?

Let me know if you guys can help.

Best regards,
-Igor Santos


Editing SharePoint forms in Word Document with InfoPath

  

Hello,

I have a SharePoint library on a MOSS 2007 server with six metadata columns. When a document is saved, a workflow populates five of those columns. However, when a document is open, the user can see all six of those columns (when they only need to enter data into one). I figured out how to edit the form that appears in Microsoft word using Infopath. However, I don't know how to get rid of the fields I don't want users to see. If I delete those fields in the form, the workflow gives an error.

Does anyone know of a good resource that explains editing these forms that show up in a document using Infopath?

Thanks!


T


Submitting Infopath forms to a Sharepoint Library - how can I generate a unique name for each record

  

I have published an Infopath form to a Sharepoint Library. What is the best way to ensure the following:

1. have a name per saved form (I do have a name field which has a set certain amount of available names in it which I am currently using as the form name - coming from an XML file)
2. users can edit already submitted forms without changing the name of the saved form
3. Ensure that users who may create a new form which happens to have more or less the same data as a previously saved form don't end up overwriting the existing one and hence I end up loosing saved data?

Using the name field + allow overwrite will allow me to have a unique name for the form and allow it to be overwritten but if I create a new form with the same name and maybe just a few small differences I will overwrite the existing form which is what I don't want - someone may not realise that an existing form with the relevant information already exists and we could loose already saved information

Any advice would be greatly appreciated.

Thanks,
Declan.


Customizing SharePoint List Forms in InfoPath 2010

  
Learn how to customize the forms for viewing and editing items in a SharePoint list with the InfoPath Designer, and then take the forms offline using SharePoint Workspace.

Sample: Customizing SharePoint List Forms in InfoPath 2010

  
Explore the code sample as you learn to customize the forms for viewing and editing items in a SharePoint list with the InfoPath Designer, and then take the forms offline using SharePoint Workspace.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend