SQL Server (OleDB)

To create a connection to a SQL Server database using OleDB you need to select the SQL Server (OleDb) option in the list.

You then need to enter a name for the connection and an optional description.

In the SQL Server Connection section you need to enter in name of the SQL Server and SQL Instance Name (if applicable) you are connecting to E.g. SQL01, SQL01\SQLExpress, server.database.windows.net.

You also need to enter in the name of the Database you are connecting to, and should select the Network Library type applicable.

If you need to use SQL Authentication to connect you can enter in the required credentials. Otherwise leaving these blank means the Ouvvi service credentials will be used.

Note that SQL Azure DB expects the username in the format username@database.database.windows.net.

To finish creating the connection click Save and it will be added to the connection library list.