?
Solved

Infopath Data Connection Using SharePoint List

Posted on 2011-03-06
4
Medium Priority
?
391 Views
Last Modified: 2012-06-27
I'm trying to add a Sharepoint WSS 2.0 list as a data connection in Infopath 2007 and it keeps saying the address is not valid.  What's the right syntax?  Here's what I entered:

http://teamservices.gcfs.com/default/risk/tcs/Main_Portal/Lists/_vti_bin/owssvr.dll?Cmd=Display&List={0EC80ABF-B2D7-464F-B62E-CFA931CC2DB3}&XMLDATA=TRUE&noredirect=true

Here's the path to the List:
http://teamservices.gcfs.com/default/risk/tcs/Main_Portal/Lists/Test%20TCS%20to%20GCFS%20Transfer%20Checklist/AllItems.aspx
0
Comment
Question by:error_prone
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 28

Expert Comment

by:clayfox
ID: 35051212
you are putting too much,  InfoPath will browse sharepoint so just enter the teamservices.gcfs.com/default/risk/tcs/main_portal

Then InfoPath will show you the lists and let you select.
0
 

Author Comment

by:error_prone
ID: 35051877
I tried that and it says no data connection libraries are found.  Does not having Form Services installed cause this problem?  This is a SharePoint WSS 2.0 site without Form Services.
0
 
LVL 28

Expert Comment

by:clayfox
ID: 35051932
A list should be fine.

I would try a couple different urls, try different levels. Make sure you have full access to it, permissions might affect it.

0
 
LVL 12

Accepted Solution

by:
Hairbrush earned 2000 total points
ID: 35055201
Hi error_prone

Data Connection Libraries (DCLs) were a new feature introduced in WSS 3.0.  They do not exist in WSS 2.0.

You should however be able to use your WSS 2.0 list as a data source.  However your connection configuration would need to be stored either locally in the .XSN file, or on  WSS 3.0 or above server.

In InfoPath you'd click on "Design Tasks"->"Data Source"->"Manage Data Connections..."->Add->"Receive Data"->"SharePoint Library or List" and then enter path to the list as follows:

http://teamservices.gcfs.com/default/risk/tcs/Main_Portal/Lists/Test%20TCS%20to%20GCFS%20Transfer%20Checklist/AllItems.aspx
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

765 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