InfoPath Dev

Hi Steph, thanks for the SSO explanation, I tried this but still got errors. I seem to have found a solution to the problem....I had to publish the form as an administrator approved form, adding the form into the farm in Central Administration and then activating the form at the site collection level. All is working now Thanks for all the help ...

Just an update, I edited the udc file to use explicit credentials, using a domain login I know has access to the database, can login, and can view the table i am trying to view with the form. I still get the error.... When in debug, the connection fails at the point below:  //Have InfoPath construct an SQL command that is based on all ...

Hi Patrick, Thanks very much for the reply. I did try getting the udcx file to use an SSO mapping to give it elevated priviledges. I dont mind hard coding some credentials into the connection file if it will get it to work (there is no real sensitive data in this database). Could you give me an idea how to do this? and what permissions the ...

Please, any help on this would be great...starting to pull my hair out over this now (what I have left anyway) - :-)  Thanks in advance of any assistance Cheers Chris

Hi there everyone, I wanted to use wildcards in a serach form which queries a SQL database for student attendance. I followed the guide found here to write the appropriate code, which works fine in the client application....in fact it works great!!  My actual code is shown below: public void btnQuery_Clicked(object sender, ClickedEventArgs ...