Qdabra Database Accelerator

Re: QueryBuild cannot connect to Sharepoint list

Marzipan — Thu, 22 Apr 2010 13:56:35 GMT

That worked! I have saved the "form.xml" as a sample. UGH!

Re: QueryBuild cannot connect to Sharepoint list

ErnestoM — Thu, 22 Apr 2010 12:46:51 GMT

For the Web Service Prefix URL, you should be using just http://<servername>

Also, f you changed the folder name during installation (from qdabrawebservice to qws0407) then you'll need to change value of the Web Service Name.

Please try this and let us know how it goes. Thanks!

Re: QueryBuild cannot connect to Sharepoint list

Marzipan — Thu, 22 Apr 2010 12:32:37 GMT

Here it is!

Re: QueryBuild cannot connect to Sharepoint list

ErnestoM — Wed, 21 Apr 2010 17:26:13 GMT

Can you attach a screenshot of the error message? You can do this via the Options tab. Thanks!

Re: QueryBuild cannot connect to Sharepoint list

Marzipan — Wed, 21 Apr 2010 16:14:37 GMT

Changed sharepoint list url to:

http://<servername>/EventDemo/Lists/EventItems/

And am getting the following:

The query cannot be run for the following DataObject: DescribeListSchema
InfoPath cannot run the specified query.
The SOAP message cannot be parsed.

Re: QueryBuild cannot connect to Sharepoint list

ErnestoM — Wed, 21 Apr 2010 14:55:21 GMT

For form libraries you have to remove the /Forms/AllItems.aspx section of the URL. For a custom list such as yours, I would assume that the URL needs to be "trimmed" as well. I would suggest:

1. Try to use QueryBuilder with a different library. If it works connects and allows you to select columns, this tells us that you don't have any permissions, server or set up issues.

2. Then try to play with the URL. Try, for example, http://<servername>/EventDemo/Lists/EventItems/

Let us know how this investigation goes.

Thanks!

QueryBuild cannot connect to Sharepoint list

Marzipan — Wed, 21 Apr 2010 14:46:11 GMT

I am following the video demo and trying to connect to a sharepont list, it is not a form library but a custom list, I assume that does not make a difference.

I am getting a "failed connection to data source"

http://<servername>/EventDemo/Lists/EventItems/Events.aspx

the web service and sharepoint are on the same server.

I installed QueryBuilder on my desktop, I assume that is ok.