Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 804
  • Last Modified:

Cannot populate Infopath drop-down with SQL data

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
fjkilken
Asked:
fjkilken
  • 2
  • 2
1 Solution
 
clayfoxCommented:
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
 
fjkilkenAuthor Commented:
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
 
clayfoxCommented:
I would verify InfoPath can connect successfully to the SQL data via ODBC as a test.
0
 
fjkilkenAuthor Commented:
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now