InfoPath Dev

Hi all, I'm working in a no-code (or limited code) environment and I need to dynamically query a SQL database based on the selected value of a drop down control. I'm using InfoPath 2010, publishing to SharePoint 2010, and accessing SQL Server. I can do this in code by updating the commandText with C#, but the AdoQueryConnection adoconnection = (AdoQueryConnection)DataConnections["Data_Connection"] and adoconnection.ExecuteQuery() are not allowed in a SharePoint sandboxed solution. I tried tweaking manifest.xsf with no luck. I know there are a lot of restrictions here, but I'm hoping someone knows a way. Thanks for your help!

You should check out the QueryDB web service in DBXL.  Without any code, you can use a data connection to the web service to query SQL databases and return data back to your InfoPath form as a secondary schema.

Here is a link for more info and to download a trial: http://www.qdabra.com/en/products/DBXL.aspx