Re: QueryDB error with query builder

cm1818 — Thu, 02 Feb 2012 18:53:55 GMT

That was the issue. It is now working. Thanks so much for the help!

Re: QueryDB error with query builder

Jimmy — Thu, 02 Feb 2012 18:13:32 GMT

Could you verify that the service account DBXL is using (perhaps the host server's NETWORK SERVICE) has adequate permissions to query that server and database?

Re: QueryDB error with query builder

cm1818 — Thu, 02 Feb 2012 17:07:07 GMT

I have attached a screenhot. I have also tried to use the alias "custom" for the server name as well with the same error.

Re: QueryDB error with query builder

Jimmy — Thu, 02 Feb 2012 16:19:48 GMT

Could you post a screenshot of how you've filled out the top part of QueryBuilder? I believe that QueryBuilder's ability to get the DB schema doesn't depend on how web.config is filled out, so I think that's a separate matter.

QueryDB error with query builder

cm1818 — Thu, 02 Feb 2012 15:15:31 GMT

I am trying to use the QueryDB web service with the query builder. I was able to use this on the default server and database. I would like to use the web service on a different sql server and database. I have added the following custom server and CMFCU database to the web.config:

When I try to connect to the server and DB through query builder, I get the following errors:

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

--------

A required data source is not available.

---------

Could not determine the database schema.

Any help would be greatly appreciated.

Qdabra Tools

Re: QueryDB error with query builder

Re: QueryDB error with query builder

Re: QueryDB error with query builder

Re: QueryDB error with query builder

QueryDB error with query builder