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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Data Connections Stopped Working In Infopath 2010

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :SharePoint
 

I have an Infopath 2007 web enabled form that I converted to Infopath 2010.  I also converted the data connection to 2010.  The server is also SP2010.  Now when the form is accessed via the browser the following error occurs.

"You do not have permissions to access a SharePoint list that contains data required for this form to function correctly."

It works ok in preview mode.  And nothing else has changed.  The production 2007 Infopath version of this form still works.  Security is set to "Domain".  And there is no issue with access to the data connection list.  What am I missing? 




View Complete Post


More Related Resource Links

InfoPath 2010, Multiple Repeating Sections have same name, Diff data connections using same SQL Serv

  
I've created an InfoPath 2010 form that has three Repeating sections and each one uses a different data connection but all three connections use the same table in SQL Server... "Accounts".  Now you might ask why I would do this? Well I need different sets of data in each section and it all resides in the same table in the repository. Also, sometimes one section will not have information and I do not want a bunch of blank fields displaying in the repeating section. So I split the data into separate sections. Now here is the challenge for you guru's out there. :) I want to use one column in the 3rd repeating section  to refer back to another column in the first repeating section.(for referential integrity) Unfortunately since they both use the same table in the database they possess the same name under advanced view:  myFields/dataFields "d_:Accounts". In fact all three of my repeating sections have the same name based upon the database table used in the data connection. In the SQL statement I attempted to rename each of the connections via the statement. I have not tried to give the table an alias in the statement yet. Will try that one next. 1. Is there a simple way to rename the repeating Section from "d_:Accounts" to something else so that  they are each unique? (Without using backend code as I've only used InfoPath/SP/S

Stored Procedure stopped working in Visual Studio 2010; System.Data.SqlClient disabled?

  

Hi,

In Visual Studio 2010, I have a webform, with a button that attempts to manipulate a SQL table that has a lot of data (several years & archives of 12 people's emails: emailID, bodies, to, cc, bcc, date/time).  Problem has always been that with so many emails (500,000), I had to break up the manipulation jobs a bit, or VisualStudio/ASP.Net development server would freeze up running those SQL stored procedures.

So I determined, for each (.pst) email store, a unique series that was in each emailID - for instance, person A would have 00000195195xxxxx as their emailIDs, and person B would have 00000123456xxxxxx as their email IDs - and used those 30 [or so] identifying flags to recursively call a function that until yesterday was running my SQL stored procedures just fine. 

YEsterday, while that was running, for giggles, I rebuilt the index on my table, and freaked out the development server by accident.  I had to rollback the database using SQL Server Management Studio, or the database was "Suspect".

Now, my SQL Stored Procedure in that recursively called function won't run, despite the fact that the original SQL Query [that gets the identifying flags into a Datatable, and runs the sproc on each "row"] works just fine.

I think it's a setting, to protect me ... but can't

Stored Procedure stopped working in Visual Studio 2010; System.Data.SqlClient disabled?

  

Hi,

In Visual Studio 2010, I have a webform, with a button that attempts to manipulate a SQL table that has a lot of data (several years & archives of 12 people's emails: emailID, bodies, to, cc, bcc, date/time).  Problem has always been that with so many emails (500,000), I had to break up the manipulation jobs a bit, or VisualStudio/ASP.Net development server would freeze up running those SQL stored procedures.

So I determined, for each (.pst) email store, a unique series that was in each emailID - for instance, person A would have 00000195195xxxxx as their emailIDs, and person B would have 00000123456xxxxxx as their email IDs - and used those 30 [or so] identifying flags to recursively call a function that until yesterday was running my SQL stored procedures just fine. 

YEsterday, while that was running, for giggles, I rebuilt the index on my table, and freaked out the development server by accident.  I had to rollback the database using SQL Server Management Studio, or the database was "Suspect".

Now, my SQL Stored Procedure in that recursively called function won't run, despite the fact that the original SQL Query [that gets the identifying flags into a Datatable, and runs the sproc on each "row"] works just fine.

I think it's a setting, to protect me ... but can't

wss2.0 Infopath 2007 'This form requires connections to data sources when it is loaded. At least on

  

Hi all

I have a user who receives the error 'This form requires connections to data sources when it is loaded. At least one of these connections is not available. As specified by the form designer, this form will not open' when trying to Submit an infopath form located on a WSS2.0 site.

The user has been having this issue since upgrading to Office 2007 and IE7. I have had the user run an Office Diagnostics but this has not resolved the issue.

I am not aware of any other users experiencing this issue.

Any ideas please?


Infopath Data Connections and Submit

  
We are in the process of shifting our draft system from SP 2007 to SP 2010 and we are re-visiting our Infopath forms service. Admin approved IP forms,  the templates emailed to our 12 remote 'offices' 12 Site collections -identical structure for remote locations 12 Remote user locations, never connected! ,fills in the form, selects own site, and emails back to office Custom button on form with rules reads 'selected site' and uses appropiate data connection to submit to correct Site Collection/Form Library. We are only using 1 site at the moment but obviously with 12 sites it becomes unmanagable, my thoughts;- Can we use a web service to act as an intermediary to point to correct library? Would a dataconnection library help?, or is the amount of work the same? ??? casey  

Infopath Form Data submitting to Sharepoint 2010 List

  
Making a Client intake form that once submitted will send data to  a sharepoint 2010 List called contacts. Short Summary the form will have repeating fields and alot of information to submit. I have looked and read all over but I cannot find an easy step by step guild on how to submit the form data like that. Long Summary on the sharepoint site a button will open a form for adding a new client.  once the form has been filled out and the user hits submit sharepoint will then create a User File, in clients file, and take the data and put it into contacts list. I am trying to make use of Sharepoint as I would with access, meaning the more information I have on a client the easier it will be to mail merge letters, motions, basicly any file prepaired stuff. So once I have css designed forsharepoint to make it look the way I want then the forms should intergrate perfect

vs 2010 stopped working when i close website

  
Hi, i have installed latest vs 2010 ultimate on windows 7 it works fine but as i want to close a website  it sayas vs has stopped working restart/debug what should i do?

VS 2010 Workflow -Linq Data Connections

  

Hello,

We have several workflows to build that will use a common linq data class.

What is the best way to expose this class to all WF projects?

Tried a solution with 2 projects 

  • The data class
  • The workflow with references to the data class

But the workflow always "failed on start"

Soon as I removed the references to the dataaccess project it ran OK

Thanks,

casey


SharePoint 2010 External Content Type and InfoPath 2010 - Numeric data type fields missing in InfoPa

  

Connected SQL data table to SP 2010 ECT from SQL table.  The SQL table has several fields that have a type of "numeric(3,0)".  The SP 2010 list shows all fields form SQL.  When we open up InfoPath Designer and reference the SP List data (from SQL) all of our numer fields are missing from the available fields list.

I amd going to try another data type but that hardly feels like a solution.  If anyone has any ideas please let me know!


SharePoint 2010 Centrally Managed Data Connections

  

I know it is possible to deploy connection files to a Local/ Relative connection library using WSP
http://www.screencast.com/users/jthake/folders/SharePointDevWiki.com%20Screencast/media/6cde7d2e-b883-4980-9a94-040d7626feb0

but is it possible to deploy Centrally managed Data Connections using a WSP?


InfoPath 2010 master details form, Submit data to muliple Form Library

  
I have 2 Form library
--------
Library 1 :
    Employee ID
    Employee Name
    Employee Age
--------
Library 2 :
    Employee ID
    Address
--------

I want to create one form using Info Path as master details form. i.e for Library 2 repeating field.
How we can do this any one have any idea.

I have tried to submit this form data into 2 data connection in info path, but its not working ....







Projected Fields not available in InfoPath data connections

  

Projected fields are a nice way to join lists and show fields from related lists in the same view without physically duplicating fields. Unfortunately, these projected fields are not available in InfoPath data connections. I am now tempted to duplicate data and to maintain physical copies of fields in multiple lists to overcome this limitation, but it makes me uneasy ;-) 

I must add, the InfoPath form is a list based form without code behind. 

If you guys have a better idea, please let me know. thanks.


Iko

fx Controls instead of Drop Down Lists for Lookup fields in InfoPath Secondary Data Connections

  

I have a secondary data connection with a lookup field into another list. To display the fields text value instead of the index, I am using a drop down list which gets its choices from the linked list. This information is read-only so I disabled the control via formatting rule.

A calculated value control might be better suited, but my XPath skills are not very "developed". Has anyone done this before? Taken the index from the bound field and extracted the text value from a second data connection? Thx


Iko

sharepoint 2010 variable in data connections

  

hi

how can i retrieve data from a database for the logged in user.  for eg. i wish to display personal data (on MYSite) for the logged in user.  this data is to be retrieved from an oracle database using "user name" from user information list. i have retrieved data from an oracle db using data connections. how can i insert the variable "user name" into the sql statement so that users acces only their info.

 

thanks

 


infopath 2010 not working with sharepoint 2010

  

hi all 

 

im using sharepoint 2010 and publishing my forms using infopath 2010 

im trying to publish my form to sharepoint but the infopath wizard tilling me that

"This form template is browser-compatible, but it cannot be browser-enabled on the selected site"

 

i checked the sharepoint central administration errors and warnings 

 

i checked that there is infopath service running 

 

i checked state service and checked that its connected to my site collection 

 

also i checked the infopath configuration from 

 

Configure InfoPath Forms Services 

 

to be "(Allow users to browser-enable form templates) and (Render form templates that are browser-enabled by users)"

 

i checked my form settings from " Form Library Settings > Advanced Settings" to be "Open in the browser "

 

as a final result for my tests , i can publish my form but it not browseable and i can't find the infopath service in the site collection features 

 

i almost tried everything and still trying with no good results till now. 

 

 

 

thanks 


Submitting data from Infopath 2010 to a Sharepoint 2010 list fail

  

Hello everybody,

I'm trying to submit data from an Infopath 2010 form to a Sharepoint list using the following tutorial: http://msdn.microsoft.com/en-us/library/cc162745(office.12).aspx 

However this doesn't work. The form creates new entries but when you whant to change or delete an entry, I get the following error: Object reference not set to an instance to an object. Any idea what is wrong with the code?

using Microsoft.Office.InfoPath;
using System;
using System.Windows.Forms;
using System.Xml;
using System.Xml.XPath;
using mshtml;

namespace Sharepointupdate
{
  public partial class FormCode
  {
    // Membervariablen werden in browserfähigen Formularen nicht unterstützt.
    // Schreiben und lesen Sie diese Werte stattdessen aus dem FormState-
    // Wörterbuch, indem Sie Code wie folgt verwenden:
    //
    // private object _memberVariable
    // {
    //   get
    //   {
    //     return FormState["_memberVariable"];
    //   }
    //   set
    //   {
    //     FormState["_memberVariable"] = value;
    //   }
    // }

    // HINWEIS: Das folgende Verfahren ist für Microsoft InfoPath erforderlich.
    // Es kann 

Are there any limitations in SharePoint 2010 BCS when working with large data?

  

Hi,

We are working on suggesting the best approach that would be suitable to support user data stored in SQL Server 2008. User data is huge (in Terabytes). I need to understand if there are any issues using MOSS 2007 BDC or SharePoint 2010 BCS to interact with SQL Server 2008 database tables? I understand that BCS offers a no-code solution for interacting with SQL tables, however when handling such large data, can we have better performance if Stored Procedures and ADO.Net is used to fetch and update the data?

All in all I need to understand the pros and cons in both these approaches. Any pointers, specifically to related real world case studies shall highly be appreciated. Thanks much!


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