Controls

Re: populate combobox/dropdownlist box w/ SQL data

nukkumatti — Wed, 04 Jul 2007 09:46:40 GMT

yes under tool, internet option, advanced tab - it's one of the last check boxes "Enable Windows Integreated Authentication"

Re: populate combobox/dropdownlist box w/ SQL data

ArrowWind — Wed, 04 Jul 2007 08:57:36 GMT

i am using IE

where can i find Integrated Windows Authentication?

on the internet option, i have set intranet security to low, and privacy lwvel to low. but it seems i cant find that option.

for the second thing, i can run query from auery analyzer to that database but i can't get the form working.

Re: populate combobox/dropdownlist box w/ SQL data

nukkumatti — Wed, 04 Jul 2007 08:45:35 GMT

one thing i forgot to mention. in your dataconnection sql statement you then dont use the complete sql qurey but only call "exec nameOfYourStoredProcedure"

Re: populate combobox/dropdownlist box w/ SQL data

nukkumatti — Wed, 04 Jul 2007 08:24:34 GMT

I haven't worked with browser enabled forms yet but my first idea would be that you check if Integrated Windows Authentication is check in your Browser Option. The second thing I would do is to actually store your SQL select statement as a stored procedure to your database. Like this you need to grant only execute permissions to the usp for each user and don't need to grant them access to the complete database.

Re: populate combobox/dropdownlist box w/ SQL data

ArrowWind — Wed, 04 Jul 2007 07:58:40 GMT

sorry for double posting.

but the problem still exists when i open the form on a browser, do i have to store the odc file on sharepoint server?

Re: populate combobox/dropdownlist box w/ SQL data

ArrowWind — Tue, 03 Jul 2007 06:21:11 GMT

thanks for the reply Clay.

it works great!

Re: populate combobox/dropdownlist box w/ SQL data

Clay Fox — Tue, 03 Jul 2007 05:28:50 GMT

I would check your permissoins on the SQL box first off. Ideally you can grant your self heightened permissions and get it working and then begin removing premissions back to normal and find what you need.

Then I would also check that the server name is in your trusted sites or intranet zone in Internet Explorer. Data Connections look to IE for trust and this could be affecting you too.

populate combobox/dropdownlist box w/ SQL data

ArrowWind — Tue, 03 Jul 2007 02:15:22 GMT

hi. i have search the forum about the topic above, but i can't find my answer.

i'm trying to populate a combobox with SQL data using odbc connection.and using windows authentification in the odc file

i can retrieve the data in the design mode but when i preview it, infopath encountered an error.

if i save it and open the form again, there is a message box saying that "one or more data connection that are required for this form are unavailable etc"

and if i expand the detail it shows

The query cannot be run for the following DataObject: MS_Reader
InfoPath cannot run the specified query.
InfoPath cannot connect to the data source.
Access is denied.
Access is denied.

i want to retrieve new data from SQL table whenever the form is opened or called.

also i'm facing the same problem on the drop down list box.

(i want to compare ordinary infopath form and browser enabled form, but combo box is unavailable n the browser enabled form)

thanks in advance.