Qdabra Database Accelerator

Re: Receiving error when creating data connection

imstac — Mon, 15 Mar 2010 18:04:59 GMT

Ugh, I totally forgot about that. That worked. Thanks.

Re: Receiving error when creating data connection

ErnestoM — Mon, 15 Mar 2010 17:03:58 GMT

Hi Stacie,

You'll need to use the alias surrounded by pound (number/hash) signs, like this:

Can you try that and let us know if it works?

Thanks!

Re: Receiving error when creating data connection

imstac — Mon, 15 Mar 2010 16:55:35 GMT

Ernesto,

I have already completed this step. Here is part of my web.config file where I added everything. My database server is aussql and the my db is CMS. Did I miss something?

Re: Receiving error when creating data connection

ErnestoM — Mon, 15 Mar 2010 16:44:42 GMT

Hi Stacie,

Before you can begin using a database/table with the QueryDB web service, the database and table being queried need to be added to DBXL’s web.config file. You'll be adding a line like <database alias="DB_Alias" name="SampleDB" server="default" /> to the configuration/qdabra.dbxl/enumdb/databases node.

You'll also add a line for the table.

I can write a more detailed post later today; or there is more info on this previous post:

http://www.infopathdev.com/forums/t/14301.aspx

Receiving error when creating data connection

imstac — Mon, 15 Mar 2010 16:29:34 GMT

Hi, I am receiving an error when trying to create a data connection. Here are my steps:

Add New Connection
Create new connection to receive data
Select Web Service
Key in web service details http://AUSDEV1/QdabraWebService/QueryDB.asmx?WSDL
Select GetColumnsXMLStrQuery
Enter Sample Value code (which I created from using QueryDB Builder with no issues) <query database='CMS' table='MaxJobNumber' maxrows='2'><columns><column name='MaxJob'/></columns></query>
When I click Next I get the following error:

The SOAP response indicates that an error occurred on the server:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.ArgumentException: Database not registered for use: 'CMS.'
All databases used by QueryDB must be specified in web.config
   at Qdabra.DataBaseService.QueryDBService.CheckForDatabaseInConfig(String databaseName)
   at Qdabra.DataBaseService.QueryDBService.GetDatabaseName(String& database, String table, String[]& columns, String& connectionString)
   at Qdabra.DataBaseService.QueryDBService.GetRequestedData(String database, String table, String[] columns, Boolean distinct, String whereClaus, String orderByClaus, Int32 maxRows, Int32& rowCount)
   at Qdabra.DataBaseService.QueryDBService.InternalGetDataSet(XmlNode queryXml, String& database, String& table)
   at Qdabra.DataBaseService.QueryDBService.GetColumnsXMLQuery(XmlNode queryXml)
   at Qdabra.DataBaseService.QueryDBService.GetColumnsXMLStrQuery(String queryXml)
   --- End of inner exception stack trace ---

I checked to make sure the database server and database I am using is set up in my webconfig and it is.

Any ideas why this is happening?