Cannot populate Infopath drop-down with SQL data
Posted on 2008-10-14
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?