Data Connections

Re: Populate a dropdown listbox with data from an SQL Database

Jo-Anne Alfafara — Tue, 28 May 2013 01:36:02 GMT

Hi akile,

I wonder - if you test the form in preview mode, do you get the same error? If you're getting the same error, I'd suggest checking that you have enough SQL permissions.

Re: Populate a dropdown listbox with data from an SQL Database

akile — Wed, 22 May 2013 13:13:51 GMT

Yes. I go through and convert to ucdx and approve it on sharepoint, but when I open my form, it still gives me issues. I know it is this data connection because when I remove it, my form opens fine.

Re: Populate a dropdown listbox with data from an SQL Database

Jo-Anne Alfafara — Wed, 22 May 2013 01:48:34 GMT

Hi akile,

Welcome to the forums. When you said you've converted the data connections, did you convert it to a UDCX file? Have you approved that UDCX in your SharePoint's data connection library?

Thanks,

Jo-Anne

Populate a dropdown listbox with data from an SQL Database

akile — Thu, 16 May 2013 19:15:47 GMT

I have a form that is to be filled out on Sharepoint. When the form is finished, the inspectors are to select their name from a dropdown list and then a text box will populate with their electronic signature. I am using Sharepoint 2007 and Infopath 2010 and creating a 2007 form. I have tested the form without the data connection and it opens fine, but as soon as I add a connection, it gives me an error "An error occurred accessing a data source." I have done everything I know to do and it doesn't work. I've converted the connection and tested and not converted the connection and tested it. Can anyone give me the steps to create my listbox and populate it with the data from my SQL database so it will work on Sharepoint?