Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a data connection to SQL database already set and for the form to query the database on form load. In the dropdown list property I have it pulling from an external data source and in the entries, value and display name I have select the correct columns.

When I go to preview the dropdown is blank. I'm not finding anything online to help me figure this out.

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

Don't have a lot of information to go off with your question, perhaps screenshots of your data connections and such could help us be more specific.

Microsoft does have a tutorial on how to use SQL data connections in InfoPath (it's for 2007, but still applies): http://office.microsoft.com/en-us/infopath-help/add-a-data-connection-to-a-microsoft-sql-server-database-HP010092823.aspx. You might run through the tutorial to ensure you didn't miss anything.

Another note: SQL connections don't work with an InfoPath Web Form. You would need to use web services to interact with your data in that scenario.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.