How can we help?

Custom Connection String Sage 50 and Peachtree

You are here:
Go Back

How to create a Custom Connection String for database access with Sage 50 and Peachtree Accounting Software.

A Custom Connection String allows access to your Sage 50 or Peachtree Accounting Database.  The basic parameters are:

  • XpoProvider
  • Database
  • User ID
  • Password

This is an example of a Custom Connect String:

XpoProvider=Pervasive;Database=e:\Peachtree\2019\Company\Sample\PTXA\BCS\;User ID=Peachtree;Password=Peachtr1;

Notice each parameter is followed by an equal sign with its value and then a semicolon.

The parameter values are self-explanatory except for the XpoProvider which is always Pervasive for Sage 50 and Peachtree Accounting databases.

XpoProvider=Pervasive;Database=e:\Peachtree\2019\Company\Sample\PTXA\BCS\;User ID=Peachtree;Password=Peachtr1;

The Database is the location of the database.  Each Sage 50 and Peachtree Companies database is within it own folder (subdirectory).  Make sure you end your data locations with an \.

XpoProvider=Pervasive;Database=e:\Peachtree\2019\Company\Sample\PTXA\BCS\;User ID=Peachtree;Password=Peachtr1;

 


You create Custom Connection Strings in the Data Source Wizard area.

 

Sample Screens from the Data Source Custom String

DataSource Wizard Custom Connection Strings Screen 1
DataSource Wizard Custom Connection Strings Screen 2

 


Special Uses

There are 2 additional parameters that are not required but available for special uses:

  • Server Name
  • Pooling

XpoProvider=Pervasive;Database=e:\Peachtree\2019\Company\Sample\PTXA\BCS\;User ID=Peachtree;Password=Peachtr1;Server Name=localhost;Pooling=False;

Server Name – If your data is located on a special server or across the internet you can enter your server name or the IP address.

Pooling – (True/False) Connection Pooling allows for connections to your database to be reused.  When pooled connections are reused rather than created each time a connection is requested.  This speeds up applications and saves computer resources.  The default is True to automatically reuse connections, you only need to set to False to turn it off.

Depending upon your environment it may be necessary to turn off the pooling by setting Pooling=False;  This may free the database connection so you are not preventing other users from requesting special rights to the database.

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?
Previous Custom Connection Strings Examples
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.

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