SQL Database Integration

Re: Query Sql from infopath help

BrunoAdv — Mon, 05 Mar 2012 20:03:55 GMT

Hello Hilary,

I tried using SSPI and also tried using a defined username and password and saved the userID and password to the UDCX, both ways work fine from the infopath application but do not work at all once i publish them to sharepoint and open the form in a browser. I will look into SSO, with sharepoint and SQL. If you know any good guides please let me know.

Thank you for the reply.

Re: Query Sql from infopath help

Hilary Stoupa — Mon, 05 Mar 2012 16:15:05 GMT

That's a tough one. You'd think if the issue was authentication, the error log would include that. Searching just on DB_E_ERRORSOCCURRED(0x80040E21), I see some results that indicate this may occur with Integrated Authentication - is that what your UDCX is using? I wonder if changing to SSO would help....

Query Sql from infopath help

BrunoAdv — Fri, 02 Mar 2012 17:57:19 GMT

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." 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