Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Unable to connect to Data source through Infopath

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 11-06-2009
Member
 
Join Date: May 2008
Posts: 255
Unable to connect to Data source through Infopath
  

I have Microsoft Office InfoPath 2007, i have tried number of thing to solve this problem, and to do that i followed these following steps :


When I opened an application to design a form template using 'Database' option, creating a new Data Source pointing to a database in local SQL Server 2005, i keep the default template layout, as i have read in the blog I run the Drag one query field in the 'Query' layout table then have selected Select 'Preview' from the toolbar by entering the valued in the query field i received the following error message:

InfoPath cannot connect to a data source

when i again try to connect it to the data source it prompt me saying "Try to connect". To use previously used data, click "Work offline".

Reply With Quote
  #2  
Old 11-06-2009
Member
 
Join Date: Dec 2008
Posts: 128
Re: Unable to connect to Data source through Infopath

check your SQL database permissions against what login you are using for SharePoint. I changed my Trust level of my form to FULL TRUST and then it was fixed. You need a group account or indivdual access with at least select/read access to the database tables. First to check is the View_DowntimeAlertForm.If the above is the situation then open up the Data Sources window (Tools – Data Connections) and make sure that the data connection is set up properly and the data source is in place, working and serves requests.
Reply With Quote
  #3  
Old 11-06-2009
Member
 
Join Date: Feb 2008
Posts: 180
Re: Unable to connect to Data source through Infopath

If the above error is shown when user does some action like clicking on button, then you need to check the Rules in the properties of that control (button) and then again need to ensure for those data sources/connections.Go to Tools->Form Options,under Security and Trust in the Category Pane, Uncheck "Automatically determine security level (recommended)" click the option button labeled "Full Trust". The infopath form is trying to talk to a service which is hosted in a different domain and it can’t trust it. What is the trust level of the form you maintained in your Data source.

Tools -> form options-> Security and Trust

I would assume you have setup using Windows Authentication on the connection to SQL.
Reply With Quote
  #4  
Old 11-06-2009
Member
 
Join Date: Feb 2008
Posts: 121
Re: Unable to connect to Data source through Infopath

Right click on the Webservice folder(Where U ve published i.e. Under Virtual Dir)-->Propertie-->Security-->Add Everyone and Give Only Read Access.The infopath form is trying to talk to a service which is hosted in a different domain and it can’t trust it. So that Everyone can access the Datasource, which your Web service is producing.The only way to go is setting the security and trust to ‘Domain’ and converting the existing data connections or just the cross domain connections to Universal Data Connection (UDC) format.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Unable to connect to Data source through Infopath"
Thread Thread Starter Forum Replies Last Post
Not able to Paste Data from any source to Excel M.N.S MS Office Support 2 24-02-2012 05:56 PM
Unable to connect LG VX3200 with given data cable Anna Hard Reset Portable Devices 6 31-12-2011 02:54 PM
Unable to install Office 2007 - InfoPath.en-us/InfLR.cab missing? Bloom Office Setup 4 27-10-2011 02:37 PM
MySQL database as data source in WP7 Obessed Portable Devices 3 26-10-2010 09:27 PM
Unable to connect dialup data card Nair India BroadBand 3 18-02-2009 03:50 PM


All times are GMT +5.5. The time now is 09:33 AM.