The purpose of this article is to show the different connection strings used for the ARIES Connector


Provider: OleDB

When to use: Connecting to Access databases (.accdb and .mdb)

Examples:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:/Users/name/aries.accdb;Persist Security Info=False;
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.


Provider: ODBC

When to use: Connecting to relational databases (Oracle, SQL Server)

Examples:

Driver={SQL Server};Server=\\serverName;Database=dbName;Trusted_Connection=Yes; 

OR

Driver={Microsoft ODBC for Oracle};Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=199.199.199.199)(PORT=1523))(CONNECT_DATA=(SID=dbName)));Uid=myUsername;Pwd=myPassword;


Provider: SQLServer

When to use: Connecting to SQL Server

Examples:

Server=\\serverName;Database=dbName;Trusted_Connection=Yes;

For additional Information on ARIES Connector documentation, click here