Qdabra Database Accelerator

Re: Qdabra Query Builder error.

Jimmy — Wed, 31 Aug 2011 03:49:26 GMT

Hello Jtcom,

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

Re: Qdabra Query Builder error.

Jtcom — Tue, 30 Aug 2011 21:23:02 GMT

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

Re: Qdabra Query Builder error.

Jtcom — Tue, 30 Aug 2011 21:05:55 GMT

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”

Re: Qdabra Query Builder error.

ErnestoM — Tue, 30 Aug 2011 20:56:59 GMT

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:

Does something like this reproduce the same error?

Re: Qdabra Query Builder error.

Jtcom — Tue, 30 Aug 2011 20:46:42 GMT

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.

Re: Qdabra Query Builder error.

ErnestoM — Tue, 30 Aug 2011 20:31:28 GMT

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.

Qdabra Query Builder error.

Jtcom — Tue, 30 Aug 2011 19:35:55 GMT

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