InfoPath Dev

ERROR: Data adapter failed during OnLoad: The remote server returned an error: (503) Server Unavailable. I have had the this InfoPath form "working just fine" displaying different drop down values coming from SQL DB via web service call (with UDCX file having the connection details etc..) But after the recent windows update (on this ...

Isn't your main data connection named "Main"?

I am now trying to be more complicated.   I have changed the formula to:   concat("ModifySqlQuery /dsname=PB_InProgress_FC_Units /where=where (Forecaster = N'", QueryChange, "'") I'm getting the datasource not found.  This is the main dataconnection.  Below is the SQL code from the main ...

Hi Ernesto,     changing the xpath solved my problem   Thanks, jason

Hi Hilary,     thank you for all of your help, I was able to get this solution working with the formula that you provided. I am planning on posting a sample of my solution for others to follow if they have the same requirement/issue.   thanks, jason

OK, I got it working.  Took me a bit but I remembered the note that said "Assumes that this SQL data connection does not contain a where clause already, no sorting and no joins" .  I thought I had removed the sorting but when back and double checked and had not.    Thank you for your help.  :)

Yes, DBXL v2.5 does support SQL Server 2008 R2. Forms are submitted to DBXL, and then DBXL maps to SQL and SharePoint according to the mapping that has been set up.

Thanks for the quick reply. So Qdabra, does support SQL Server 2008 R2? It is not listed under the supported platform on the site. I will be able to submit to both the SQL Database and Sharepoint document library, together?

I copied the where statement and still got the message Incorrect syntax near the keyword 'WHERE'. Is there a way to display the SQL statement that qrules created? 

Hi Sejal, Yes, DBXL will allow you to do this without having to write your own web service. Here is a video demo that shows submitting from InfoPath to SQL using DBXL.  This video might also prove helpful. You can download a free trial of DBXL and try it out before you decide whether it fits your needs, of course. Download your copy at ...