Solved

Cannot populate Infopath drop-down with SQL data

Posted on 2008-10-14
4
792 Views
Last Modified: 2012-06-27
Hi
I'm trying to populate an Infopath drop-down box with data from a view on SQL server but having a problem.
I am using an ODC file on my MOSS (Sharepoint 2007) site to connect to the drop-down
ie; using the Data Connection wizard and selecting the ODC file from the list of Data Connections (I have already verified that I can extract data using the ODC file in Excel so the ODC does work for that purpose) but it gives me the following error:

The form contains XML that cannot be parsed:
A string literal was expected, but no opening quote character was found.

Line 6, Position 18
<meta http-equiv=Content-Type content="text/x-ms-odc; charset=utf-8">
-----------------^

I'm thinking that the format of the file may be incorrect = any ideas?


thanks

Fergal
0
Comment
Question by:fjkilken
  • 2
  • 2
4 Comments
 
LVL 28

Expert Comment

by:clayfox
Comment Utility
I would try a simple test case with a test table of an integer and simple text field and try to connect via SP and InfoPath just to verify your setup.
Make sure you have some sample data.

You could also try connecting to the ODBC data directly in InfoPath just to make sure the data format and content is acceptable.

Lstly, does the Data display properly when viewed in SharePoint?
0
 

Author Comment

by:fjkilken
Comment Utility
the actual data renders fine in Sharepoint - I think it is something to do with the format of the .ODC file as indicated by the error
0
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
Comment Utility
I would verify InfoPath can connect successfully to the SQL data via ODBC as a test.
0
 

Author Closing Comment

by:fjkilken
Comment Utility
thanks - that hint set me on the road to resolviing the issue - I actually had to save the ODC file locally, thne convert and upload the ODC file to a UDC file in the Sharepoint data Connections library
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

743 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now