How can we help?

Stored Connections

You are here:
Go Back

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.
Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Previous DSStudio Viewer Program Options
Next Options and Settings
Table of Contents

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.  Reduce file size increase program 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.