Re: trying to use QueryDB

cm1818 — Mon, 19 Dec 2011 21:49:59 GMT

I found out access was being denied when it was trying to install the DAT. I am now able to get the web service working. Thanks so much for your help!

Re: trying to use QueryDB

ErnestoM — Mon, 19 Dec 2011 19:03:41 GMT

Thanks for the additional information. The trial download we offer on our website comes with a trial license already incorporated into it. I can think of two possibilities:

1. The installer (MSI) is old, and the trial license has passed its expiration date. If so, you can download a new trial from Qdabra.com.

2. There was an error during installation and the trial did not install correctly. You can check the Qdabra log in event viewer (eventvwr) to check whether there were any errors during installation. Can you check?

Thanks!

Re: trying to use QueryDB

cm1818 — Mon, 19 Dec 2011 18:58:07 GMT

Hi,

When I open the DAT, i don't have a license file loaded. Where would I find that for the trial?

Re: trying to use QueryDB

ErnestoM — Mon, 19 Dec 2011 18:14:00 GMT

Hi,

I'm sorry you've encountered this issue.

Could you please open the DBXL Administration Tool (DAT) and check the Licensing screen?

I'm curious whether you have an expired trial license, or whether the license you have does not include QueryDB.

You can attach a screenshot of the Licensing view via the Options tab when replying.

Thanks!

trying to use QueryDB

cm1818 — Mon, 19 Dec 2011 18:09:22 GMT

I have installed the standalone trial version. I am trying to use the querydb service and am getting the following error. I have used the query builder to generate teh xml. When i go to the infopath form and add another data connection, the error appears after I enter the first sample xml (step 1) from the query builder. The database i am trying to connect with is on the same server as the installed DB's during installation. Any help would be greatly appreciated.

The SOAP response indicates that an error occurred:

Error L0003:
----------------------
LicensingQueryDBLicenseExceeded
----------------------

<detail><ExceptionDetail xmlns="http://schemas.datacontract.org/2004/07/System.ServiceModel" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><HelpLink i:nil="true"/><InnerException i:nil="true"/><Message>Error L0003:
----------------------
LicensingQueryDBLicenseExceeded
----------------------
</Message><StackTrace>   at Qdabra.QueryDB.QueryDBService.CheckLicenseLimits()
   at Qdabra.QueryDB.QueryDBService.FindAlias(String dbAlias, String& connectionString)
   at Qdabra.QueryDB.QueryDBService.GetConnectionString(String database, Boolean& isDbxlDb)
   at Qdabra.QueryDB.QueryDBService.ProcessInputs(String database, String& table, List`1& columns)
   at Qdabra.QueryDB.QueryDBService.GetRequestedData(String database, String table, List`1 columns, Boolean distinct, String whereClaus, String orderByClaus, Int32 maxRows, Boolean countOnly, MySqlParameterCollection sqlParams)
   at Qdabra.QueryDB.QueryDBService.InternalGetDataSet(XmlNode queryXml, String& table, Boolean& countOnly)
   at Qdabra.QueryDB.QueryDBService.Qdabra.QueryDB.Services.IQueryDBService.GetColumnsXMLQuery(XmlNode queryXml)
   at Qdabra.QueryDB.QueryDBService.Qdabra.QueryDB.Services.IQueryDBService.GetColumnsXMLStrQuery(String queryXml)
   at SyncInvokeGetColumnsXMLStrQuery(Object , Object[] , Object[] )
   at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
   at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)</StackTrace><Type>Qdabra.QueryDB.QueryDbException</Type></ExceptionDetail></detail>

Qdabra Database Accelerator

Re: trying to use QueryDB

Re: trying to use QueryDB

Re: trying to use QueryDB

Re: trying to use QueryDB

trying to use QueryDB