InfoPath Dev

I am in design mode in Infopath 2007 and I have one dropdown list box. and I have datasource from sharepoint list and there are five dropdown menu. Out of five menu, one menu item is very long about and longer than the length of the dropdownlist box width. In preview mode , if I click that dropdown list box I can see that long menu item completely ...

I cannot create external list because of permission and there are like 100K records on that table. So, I think I have no choice other than web service. Is it possible to send link related to web service that solve my problem or any hint to start from. I would really appreciate your help

I have an access to SQL database and I populate dropdowns in Infopath using SQL database as an external datasource. when I publish that abc.xsn file to a network location( which is Sharepoint document library) the end users are unable to see the drop downs because they do not have acess to SQL database. End users are not supposed to facilitate ...

Thank you for you reply. Is it possible to create .udcx file and setup my user name and password for auto login. Or, would it be helpful to create connection using .udcx to solve this issue.

I created Infopath 2007 blank page and inserted a dropdown box. I have external data source as SQL Database and I linked the dropdown with SQL table. I previewed and able to see the popoulated values. Then I published it network location and my network location is sharepoint document library as test.xsn . In my office, there is another user who ...