<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>SQL Database Integration</title><link>https://www.infopathdev.com:443/forums/47.aspx</link><description>For questions concerning issues in the integration of SQL and Microsoft InfoPath.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Sharepoint 2010 Infopath An error occurred querying a data source. The database returns an error.</title><link>https://www.infopathdev.com:443/forums/thread/70156.aspx</link><pubDate>Thu, 08 Sep 2011 16:57:08 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:70156</guid><dc:creator>BrunoAdv</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/70156.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=70156</wfw:commentRss><description>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</description></item></channel></rss>