Re: infopath Webform with SQL Data Connection and MOSS

noone5 — Mon, 28 Jul 2008 08:53:41 GMT

I use one of course

Re: infopath Webform with SQL Data Connection and MOSS

kimospeed — Thu, 24 Jul 2008 09:03:42 GMT

Hi,

I think you need an ID which has an access to the DB your trying to get the values.

Re: infopath Webform with SQL Data Connection and MOSS

noone5 — Thu, 24 Jul 2008 08:47:31 GMT

anyone have an idea?????

infopath Webform with SQL Data Connection and MOSS

noone5 — Tue, 22 Jul 2008 16:59:43 GMT

Hello,

I have followed all the information found in the blog concerning this sujet. I try to make an infopath browser form available in MOSS. This form has several data connection to a sql DB for drop-down list

First, i have made a form with all the options browser comptatible enabled. The data connection uses windows credentials

I have converted the data connection to a udcx file, published it in a data connection library and approved it.

I have published the form in my form template library and actived it in the site content it.

The infopath form services is configured. the option Allow cross-domain data access for user form templates that use connection settings in a data connection file is enable.

When i try to open this form in a browser, i have the following error in the tracelog

07/22/2008 18:43:32.62 w3wp.exe (0x1D70) 0x0BAC Forms Server Forms Services Runtime - Data C 82fy Warning The following query failed: RFCtest (User: "My_User_in_AD", Form Name: rfctest, IP: , Request: "Address_of_MY_MOSS_server"/_layouts/FormServer.aspx?XsnLocation=http://"Address_of_MY_MOSS_server"/personal/"Site_name"/FormServerTemplates/rfctest.xsn&SaveLocation=http://"Address_of_MY_MOSS_server"/personal/"Site_Name"/RFC&Source=http://"Address_of_MY_MOSS_server"/personal/"Site_name"/RFC/Forms/AllItems.aspx&DefaultItemOpen=1, Form ID: urn:schemas-microsoft-com:office:infopath:rfctest:-myXSD-2008-07-21T15-47-25, Type: DataAdapterException, Exception Message: The form cannot connect to the data source. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.) 9cac3695-7b24-48e9-a57a-b433a004a505

I have also tried to change the udcx file with explicit username and password. I have the same error because i use a user define with the good credentials but my user is still used to connect to the db.

Could you please help me ?

Browser Forms

Re: infopath Webform with SQL Data Connection and MOSS

Re: infopath Webform with SQL Data Connection and MOSS

Re: infopath Webform with SQL Data Connection and MOSS

infopath Webform with SQL Data Connection and MOSS