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 ?