The purpose of this article is to show the different connection strings used for the ARIES Connector
When to use: Connecting to Access databases (.accdb and .mdb)
If you experience this error: "The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered", you need to download and install the 32 bit version of Microsoft Access Database Engine 2010 Redistributable. This is provided by Microsoft here.
When to use: Connecting to relational databases (Oracle, SQL Server)
When to use: Connecting to SQL Server
For additional Information on ARIES Connector documentation, click here