Hello,
I have a infopath form that connects to a SQL database to pull data. I have a UDCX file on the sharepoint server and have gone as far as giving the form full Trust etc. The form works both locally and on the infopath client. Once published it only works on the client and not on the browser based version.
I get the following errors:
An error occurred querying a data source.
Click OK to resume filling out the form. You may want to check your form data for errors.
Hide error details
The database returns an error.
An entry has been added to the Windows event log of the server.
Log ID:5566
Correlation ID:3c970617-8754-4d6f-b47c-ec93ae4d49a7
I have looked at the logs following the correlation ID and get the following.
Data adapter failed during OnLoad: The database returns an error
The following query failed: Data
Followed by:
Type: DataAdapterException, Exception Message: The database returns an error. No error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21).)
Any help would be appreciated.
Thank you