Solved

Infopath Data Connection Using SharePoint List

Posted on 2011-03-06
4
390 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 500 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 IT Pros

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

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

717 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