Populate drop-down listbox from SQL table in Forms services

M

MS

Hi,
I've created an Infopath form that populates a drop-down listbox with data
from an sql table. For this, I created a secondary connection to recieve data
from an sql server. However, when I publish my form to my sharepoint 2007
server, the data connection fails. I tried to dig out the net but couldn't
find anything to fix my issue so any help, on how to achieve this, would be
greatly appreciated.

Thanks in advance!
 
C

Clay Fox

You need to convert the data connection to a Universal Data Connection (UDC).
Browser forms require all data connections to be UDC and hosted in Sharepoint.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Open form 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
populate listbox form database table 0
Auto Populate Fields based on Drop Down List Selection 2
Connection to sql table 4
Auto-populate Infopath form with Microsoft CRM data 2

Top