How can we help?

Custom Connection Strings Examples

You are here:
Go Back

Connection Strings for Relational Database System

Here are some examples of custom connection strings for various database systems.

Microsoft SQL Server

XpoProvider=MSSqlServer;Data Source=(local);User ID=username;Password=password;Initial Catalog=database;Persist Security Info=true

Microsoft Access

XpoProvider=MSAccess;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

XpoProvider=MSAccess;Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\mydatabase.accdb;User Id=admin;Password=;

Microsoft SQL Server CE

XpoProvider=MSSqlServerCE;Data Source=MyDatabase.sdf;Password=MyPassword

Oracle Database

XpoProvider=Oracle;Data Source=TORCL;User ID=MyUserName;Password=MyPassword

XpoProvider=ODP;Data Source=TORCL;User ID=MyUserName;Password=MyPassword

XpoProvider=ODPManaged;Data Source=TORCL;User ID=MyUserName;Password=MyPassword

Amazon Redshift

XpoProvider=Amazon Redshift;Server=;User ID=MyUserName;Password=MyPassword;Database=MyDatabase;Encoding=UNICODE

Google BigQuery




XpoProvider=Teradata;Data Source=myServerAddress;User ID=myUsername;Password=myPassword;

SAP Sybase Advantage

XpoProvider=Advantage;Data Source=\myserver\myvolume\mypat\mydd.add;ServerType=local;User ID=ASSSYS;TrimTrailingSpaces=true

SAP Sybase ASE

XpoProvider=Ase;Port=5000;Data Source=MyAseServer;User ID=MyUserName;Password=MyPassword;Initial Catalog=MyDatabase;Persist Security Info=true

SAP SQL Anywhere

XpoProvider=Asa;eng=server;uid=user;pwd=password;dbn=database;persist security info=true;






XpoProvider=MySql;Server=MyServerAddress;User ID=MyUserName;Password=MyPassword;Database=MyDatabase;Persist Security Info= true;Charset=utf8

Actian / Pervasive PSQL


XpoProvider=Pervasive;Server=localhost;UID=MyUserName;PWD=MyPassword;Data Source=C:\datafilesDirectory\


XpoProvider=Postgres;Server=;User ID=MyUserName;Password=MyPassword;Database=MyDatabase;Encoding=UNICODE


XpoProvider=VistaDB;Data Source=C:\mydatabase.vdb4

XpoProvider=VistaDB5;Data Source=C:\mydatabase.vdb5


XpoProvider=SQLite;Data Source=filename

XML file

XpoProvider=InMemoryDataStore;data source=D:\Contacts.xml;read only=True

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.
Next Custom Connection String Sage 50 and Peachtree
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.  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