Stored Connections

Stored Connections allows you simply assign a connection to a report or output.

Stored Connections store the User ID and Password in plain view.  They are a security risk and are not recommended for sensitive data or logins that provide open access to the database.

Stored Connection stores the complete connection information including the User ID and Password.  This allows you to just select the Stored Connection and you are ready to go.

Stored Connections can be useful if your report supports Quick Connect.  This will allow you just select which Stored Connection you want to use and the report will generate.

Creating a Stored Connection is easy.  You can use your DBQ Names or a Custom Connection String.  Different Database Providers will require different connection information.  The Connection Editor will prompt you for the information you need.

Stored Connection Properties

  • Connection Name
  • Default (if is the default for the database type.   This is used to automatically assign a connection to a new report)
  • Connection Type
  • The Connection information.

Maintain Stored Connections.


Maintain Stored Connections Screen 1
Stored Connection New
Creates a New Stored Connection. Follow the Connection Editor for the connection parameters. Click the Save Button to save your new Stored Connection.
Stored Connection Test Icon
Stored Connection Edit Icon
Stored Connection Delete Icon
Stored Connection Sort Icon
Stored Connection Save Icon
Stored Connections Print Icon
Test the connection.
Edit the existing Stored Connection.
Deletes the Stored Connection.
Sort the connections by name. You must click the Save Button to save the sorted list.
Saves any changes to your Stored Connection entries. Make sure you click save to commit your changes.
Prints a report for Stored Connections. Please be aware that User ID and Passwords will be shown on the report.

DBQ Names – Pervasive / Actian

Using Pervasive / Actian DSNs and ODBC with DSStudio

What is a DBQ Name?

A DBQ name is an alias to a database location.  You can set up a DBQ name that can be reused with DSStudio.  Once it is set up you can select it and enter your User ID and Password to make the connection.

If you want to run the report that does not have Sage 50 or Peachtree installed on it you will need to install the Standalone Workstation Engine and create and DBQ Name.

The DBQ Name is used by the Workstation Engine to create an alias to the location of the database. 

Sample of DBQ Names

DSStudio Viewer DBQ Entries Listing

How to Create a DBQ Name

From the DSStudio Viewer bottom Menu Select the Options/Settings popup menu.

Sage 50 Create DBQ Name Menu


Create Pervasive Database Entry DBQ Screen

Create DBQ Name Entry One

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

DBQ Entry

This is the Name or Alias Name.  It needs to be brief  (around 10 characters).  It should describe the Company Name.  It must start with Alpha Character (a-Z) and cannot contain any spaces.

This is location  (Folder/Subdirectory) of the database.  Clicking on the … to the right will open an Explorer Window.   Navigate to the location of the database folder.  If you are using a mapped drive it is best to use URI path.

Understanding URI File Path

The image below shows a sample URI File Path:

\\POWERSPEC-FL   is the server name
\E-Drive  the shared drive name on POWERSPEC-FL
\Peachtree  the name of the folder/subdirectory on the E-Drive
\2019  the name of the folder/subdirectory on the E-Drive\Peachtree
\Company  the name of the folder/subdirectory on the E-Drive\Peachtree\2019
…  Continue down to BCS Folder / subdirectory

Create DBQ Name Entry Two

Create Stored Connection


This area is optional.  Stored Connections are used by DSStudio to reuse connections.  This allows you to store the complete connection information including the Username and Password.  


 Stored Connections are convenient but also a security risk because you are exposing the connections User ID/Name and Password.   The User ID/Name and Password are encrypted within a file, but viewable within DSStudio Maintain Stored Connection screen.  

Depending upon the sensitivity of data within database you may choose not use use Stored Connections.



Check to Create Stored Connection within DSStudio.

 Connection Name – The name of the connection that you will use within DSStudio.  Again make this name descriptive of the company name.

User Name if the connection is a Sage 50 or Peachtree connection this is will always be Peachtree.

The password that was established within Sage 50 or Peachtree for access to the company database.

Once is the screen is complete, click Save to close the Create Pervasive Database Entry for DBQ.

You can now use your DBQ Name within DSStudio Reports and Outputs.

Sage 50 and Peachtree Accounting Data Services

Data Recovery

Sage 50 US and Peachtree Accounting Data File Repair Service.

 Fiscal Period Change

Change the fiscal period time for a Sage 50 or Peachtree Accounting Company.

Data Transition

Many data-related services, which include: Sage 50 Product Downgrade, Quote Removal Service, Failed Fiscal Year Close Fix, and bulk change inventory item costing.

Purge Service

Data Purging Service for Sage 50 and Peachtree Accounting.  Reducing file size and increasing program execution speed.

Sage 50 Shell Company

Rebuild your Sage 50 / Peachtree Company in half the time.

Sage 50 Quote Stripping

Unable to import transactions into a new company.  The quote " maybe getting in your way.

Get In Touch

In a world full of options, we wanted to take a moment and say thanks for choosing us.

Our Knowledgebase is available for your technical support questions. 

All Sage 50 and Peachtree Accounting support is provided for a fee.

Contact Us

Contact Info

Fort Lauderdale, Florida, USA
Minneapolis, Minnesota, USA

954 - 523 - 8570

s u p p o r t @ d s c o r p . c o m