Qdabra Tools

Re: Getting error when trying to create data connection for querydb

imstac — Thu, 21 Jan 2010 15:51:50 GMT

Yippeee! That worked. Thanks Guys!

Re: Getting error when trying to create data connection for querydb

Jimmy — Thu, 21 Jan 2010 15:33:55 GMT

You need quotation marks around the value of any XML attribute, so either:

database='#Resumes#'

database="#Resumes#"

Re: Getting error when trying to create data connection for querydb

imstac — Thu, 21 Jan 2010 15:26:26 GMT

When I use pound signs I get the following error below. The code I am entering into the sample value is <query database=#Resumes# table='Titles' maxrows='2'><columns><column name='TitleID'/><column name='Title'/></columns><sort><column name='Title' order='ASC'/></sort></query>

Am I using the wrong query from the QueryDB?

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 ---> System.Xml.XmlException: '#' is an unexpected token. The expected token is '"' or '''. Line 1, position 17.
   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)
   at System.Xml.XmlTextReaderImpl.ThrowUnexpectedToken(String expectedToken1, String expectedToken2)
   at System.Xml.XmlTextReaderImpl.ParseAttributes()
   at System.Xml.XmlTextReaderImpl.ParseElement()
   at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
   at System.Xml.XmlTextReaderImpl.Read()
   at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
   at System.Xml.XmlDocument.Load(XmlReader reader)
   at System.Xml.XmlDocument.LoadXml(String xml)
   at Qdabra.DataBaseService.QueryDBService.GetColumnsXMLStrQuery(String queryXml)
   --- End of inner exception stack trace ---
   at Qdabra.DataBaseService.QueryDBService.GetColumnsXMLStrQuery(String queryXml)
   --- End of inner exception stack trace ---

Re: Getting error when trying to create data connection for querydb

ErnestoM — Thu, 21 Jan 2010 15:14:20 GMT

Ok, I've thought of something. Can you try placing the database alias within pound signs (#, also called number sign or hash mark) when using
QueryBuilder to build the queryxml?

It's interesting because you shouldn't need a new line for a new SQL instance (<server name="default" connectionString="Data Source=(LOCAL);Integrated Security=True" />). As you've said, this is where the QdabraDBXL and QdabraUtility databases exist, so the SQL instance is already registered with DBXL.

Anyway, give the # signs a try and let us know.

Re: Getting error when trying to create data connection for querydb

imstac — Thu, 21 Jan 2010 14:56:09 GMT

The first line has not been changed and I have been using the Qdabra Administration tool with no problems. All of the Qdabra databases are located on a remote server: ausdev2. I went ahead and removed the inital catalog code from the first line though.

I checked my code based on your suggestion above and it matches what you have. Maybe the problem lies when I am entering the query into the Infopath data connection. I use the code of the first query from the query builder for the sample value of tns:queryxml, correct?

Re: Getting error when trying to create data connection for querydb

ErnestoM — Wed, 20 Jan 2010 23:23:22 GMT

Hi,

The issue might be here:

Was the first line modified? It looks like it was... that first line should point to the SQL instance where the QdabraDBXL and QdabraSamples databases were installed. In my VM (clean install) it looks like this:

So as a first step, let's try to fix that line (if you have a backup of web.config you can check whether it was changed).

The new lines (for the remote SQL instance) should be:

<server name="<instance alias>" connectionString="Data Source=<instance name>;Integrated Security=True" />

<database alias="<database alias>" name="<database name>" server="<instance alias>" />

So in your case:

Getting error when trying to create data connection for querydb

imstac — Wed, 20 Jan 2010 22:55:38 GMT

I'm receiving an error when trying to implement a static query using QueryDB. After I constructed the query in QueryDB I copied the first query listed and pasted it into the sample value for tns:queryxml. The error indicates that my database is not registered. In the instructions it states that I have to add my server and database to the web.config since the database is on a remote server. I added the code to the web.config and constructed my queries using QueryDB. Obviously, I am doing something wrong to receive the error that I'm getting. Below is my web.config code for the servers and databases tags. My remote database server is ausdev2 and the name of the database is Resumes. I have also attached a snapshot of the query created in QueryDB. Will someone tell me what I'm doing wrong? Thanks.