InfoPath Dev

Greetings.  Would love to say I am back on the forums just to post a thanks for all the helpful information and all the help from Ernesto Machado (and by the way thank you very much Ernesto) on installing DBXL, but unfortunately I have run into a issue that goes beyond my knowledge with the Query Builder tool.  With a bit of work we got the Qdabra Query Builder to connect to our database and show tables, and then used it to build a query to test pulling data into another InfoPath 2007 form, I ran through the data connection wizard until I reached the screen where I double clicked the parameter and pasted the query in the sample value line.  At that point the following error occurred, I had thought after an extended effort that we had gotten everything configured correctly in the Query Builder so I would be grateful for any help with what this error means:

 

The SOAP response indicates that an error occurred on the server:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.ArgumentException: Invalid parameter
Parameter name: queryXml
   at Qdabra.QueryDB.QueryDBService.InternalGetDataSet(XmlNode queryXml, String& table, Boolean& countOnly)
   at Qdabra.QueryDB.QueryDBService.Qdabra.QueryDB.Services.IQueryDBService.GetColumnsXMLQuery(XmlNode queryXml)
   --- End of inner exception stack trace ---

Hi!

QueryBuilder produces a couple of queryxml strings. The data connection wizard requires one queryxml to get sample data, i.e. to detect the schema of the data being returned. The error you are getting suggests something is wrong with that queryxml. Is the error happening immediately after going to the next screen in the wizard, or when the form is previewed? Can you paste here the queryxml that is producing the error?

Thanks.

The error occurs right after I hit the next button.  I recreated the error using this query xml:  <query database='ClientData' table='Client' maxrows='2' getSample='true'><columns><column name='FirstName'/></columns></query> I tried creating a query from a few other tables to see if that made a difference and got an error each time.

 

One common issue with QueryDB is that the databases are not declared in the web.config,  but if I remember correctly the error message returned in that situation will be different.

Let's try the simplest possible queryxml:

<query database='ClientData' table='Client'></query>

Does something like this reproduce the same error?

Yes the same error occurs with your simple query inserted.  Just as an FYI the information I posted was from the show details section of the dialog box that comes up with the error, the text that is shown by default in it is “InfoPath was unable to create a schema from the results of the Web service call”

One other note, we did add the database into the web.config file as per the information in the QueryDB User Manual

Hello Jtcom,

Could you please ensure that you are using the GetColumnsXmlStrQuery web method, and not the one without Str in the name?