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
Solved

Cannot populate Infopath drop-down with SQL data

Posted on 2008-10-14
4
796 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
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Caste datetime 2 64
SharePoint Search option? 3 37
Anyway to make these 2 SQL statements into one? 13 42
Addition to SQL for dynamic fields 6 47
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
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.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

860 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