Solved

Cannot populate Infopath drop-down with SQL data

Posted on 2008-10-14
4
798 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
[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
  • 2
4 Comments
 
LVL 28

Expert Comment

by:clayfox
ID: 22711774
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
ID: 22712985
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
ID: 22727879
I would verify InfoPath can connect successfully to the SQL data via ODBC as a test.
0
 

Author Closing Comment

by:fjkilken
ID: 31505859
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.

752 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