Installation and Setup

Database Accelerator (DBXL) v2.7 Installation Guide

ErnestoM — Sat, 05 Jan 2013 22:14:26 GMT

This document describes the installation instructions for DBXL v2.7. Both the server and client versions are covered.

You can download a trial of DBXL v2.7 by going to the Product page on Qdabra.com.

Click DOWNLOAD above to obtain this document.

Database Accelerator (DBXL) v2.7 Release Notes

ErnestoM — Sat, 05 Jan 2013 22:11:38 GMT

This document contains a list of known issues, troubleshooting hints and workarounds for a variety of issues related to Qdabra’s DBXL v2.7.

Getting Started with Database Accelerator (DBXL) v2.7

ErnestoM — Sat, 05 Jan 2013 22:00:23 GMT

This Getting Started guide is an introductory tutorial that will show you how to quickly familiarize yourself with some of the features of DBXL v2.7 and to setup the Expense Report form sample in DBXL on your own. After completing this document you should be able to setup your own forms in DBXL and map to SQL. This document assumes that you have already installed DBXL v2.7 (Server or Client).

Qdabra's FormInstaller

ErnestoM — Thu, 09 Aug 2012 13:26:43 GMT

FormsInstaller is a tool that allows you to install InfoPath forms.

DBXL v2.6 Getting Started

ErnestoM — Thu, 26 Jan 2012 20:49:10 GMT

DBXL v2.6 includes a fully configured Expense Report form that is installed by default. The form is also mapped to SQL and upon install the necessary tables were setup in your SQL server DB. You can use this form as is and integrate with SharePoint right away and generate Excel or SSRS reports from the installed form. This included document type and SQL mapping can also serve as a reference for how to use DBXL and how mapping to parent and children tables in SQL works when using DBXL. The sample document type is called QdExpenseReport-Sample (see Appendix for more).

This Getting Started guide is an introductory tutorial that will show you how to quickly familiarize yourself with some of the features of DBXL and to setup the Expense Report form sample form in DBXL on your own. After completing this document you should be able to setup your own forms in DBXL and map to SQL.

This document assumes that you have already installed DBXL v2.6 (Server or Client). If you have not installed DBXL 2.6 yet please see the DBXL v2.5 Installation Guide for more details.

This tutorial uses the InfoPath 2007 Expense Report sample form. For your convenience we have packaged the form with this Getting Started document, available for download above. Although the Expense Report sample form was designed for InfoPath 2007 it will work with either InfoPath 2007 or InfoPath 2010. Instructions for both InfoPath 2010 and InfoPath 2007 are included.

After you complete this tutorial you might have follow up questions; make sure to visit the DBXL Product page on Qdabra.com to find a list of all available documents. You can download a trial of DBXL by going to the Product page on Qdabra.com.

Click DOWNLOAD above to obtain this document.

DBXL v2.6 Installation Guide

ErnestoM — Thu, 26 Jan 2012 20:45:20 GMT

This document describes the installation instructions for DBXL v2.6. Both the server and client versions are covered.

You can download a trial of DBXL v2.6 by going to the Product page on Qdabra.com.

Click DOWNLOAD above to obtain this document.

DBXL v2.6 Release Notes

ErnestoM — Thu, 26 Jan 2012 20:38:25 GMT

This document contains a list of known issues, troubleshooting hints and workarounds for a issues related to Qdabra’s DBXL v2.6.

DBXL v2.6 Web Service Developer Reference

ErnestoM — Wed, 18 Jan 2012 01:23:13 GMT

This document is meant as an SDK reference for developers that will be integrating Qdabra's Database Accelerator (DBXL) v2.6 with their InfoPath forms or any other application. The document describes all of the methods in each of the web services. Click DOWNLOAD above to obtain this document. DBXL is available on Qdabra.com.

Updates to DBXL when database server name changes

ErnestoM — Tue, 17 Jan 2012 20:15:29 GMT

What happens when the database server used by DBXL changes or needs to be moved? Read this document to understand the process required for a smooth transition.

How to upgrade from DBXL v2.3 to DBXL v2.4

ErnestoM — Tue, 17 Jan 2012 20:13:33 GMT

This document describes the upgrade instructions for customers moving from DBXL v2.3 to Qdabra's Database Accelerator (DBXL) v2.4.

Click DOWNLOAD above to obtain this document.

How to install DBXL in a load balanced scenario

ErnestoM — Tue, 17 Jan 2012 20:12:25 GMT

Qdabra's Database Accelerator (DBXL) can be installed on a load balanced environment. For details, click DOWNLOAD above. A free trial of DBXL is available on Qdabra.com. This applies to DBXL v2.4 and later.

How To Increase Web Service Timeout to Allow Large Document Upload

ErnestoM — Tue, 17 Jan 2012 20:11:00 GMT

If you are having trouble uploading large documents to DBXL you might need to increase the web service timeout to allow the upload enough time to complete. This can be done on the client side with managed code, or on the server-side (which affects all Document Types) via an edit to the web.config file for the DBXL instance that is causing the problem.

Note that the web.config change noted below is intended to add the <httpRuntime> node into the system.web section, as this node does not already exist in web.config. Also note that this change is only a server-side timeout and Infopath will still timeout after 30 seconds unless you use code to set the timeout.

WebServiceAdapter2 wsAdapter = (WebServiceAdapter2)thisXDocument.DataAdapters["DataConnectionName"];
wsAdapter.Timeout = 60; // Increase to 60 seconds - Default is 30
wsAdapter.Query(); // Issue the query

JScript

var wsAdapter = XDocument.DataAdapters["DataConnectionName"];
wsAdapter.Timeout = 60; // Increase to 60 seconds - Default is 30
wsAdapter.Query(); // Issue the query

web.config change

Further reference

How to configure permissions on DBXL

ErnestoM — Tue, 17 Jan 2012 20:09:16 GMT

There are four permissions levels available in Qdabra’s Database Accelerator (DBXL): DBXL Admin, Global Level, Document Type Level and Document Level. This document will provide you with an overview of these four alternatives.

Click DOWNLOAD above to obtain this document. A free trial of DBXL is available on Qdabra.com.

DBXL v2.3 Web Service Developer Reference

ErnestoM — Tue, 17 Jan 2012 19:16:45 GMT

This document is meant as an SDK reference for developers that will be integrating Qdabra's Database Accelerator (DBXL) v2.3 with their InfoPath forms or any other application. The document describes all of the methods in each of the web services. Click DOWNLOAD above to obtain this document. DBXL v2.3 is available on Qdabra.com.

SQL Authentication vs. Windows Authentication

ErnestoM — Tue, 17 Jan 2012 19:15:38 GMT

In order for DBXL to install and connect to the SQL Server that hosts the required databases, it is often necessary to alter the security model of that server. This document explains the differences between using SQL and Windows Authentication when installing DBXL. Click DOWNLOAD above to obtain this document.