Connection Editor

The connection string specifies the configuration values required to connect to the database. The content of the connection string depends on the database driver used.

To access the Connection Editor, click on the ... icon.

Note:

The Connection Editor helps build the connection string by offering a form that contains by default the most common connection properties for the selected connection type.

You are able to update the composition of this form by changing the default property names, or adding and deleting properties.
You can also paste a connection string into the Connection string property field before opening the Connection Editor. The form will then display the fields and values that are contained in the connection string.

A typical form looks like this:

Examples of connections

SQL Server

Not named, Windows authentication

Data [Source=serverAddress;Initial Catalog=databaseName;Integrated Security=True;]

Named server, no Windows authentication

Data Source=serverName\instanceName;Initial Catalog=databaseName;Integrated Security=;User ID=username;Password=password;

Example string:

Data Source=JOHNC\SQLSERVER2016;Initial Catalog=employees;Integrated Security=False;User ID=sa;Password=myexamplepwd123

Note:

When using an alias in your connection string and the DB server does not have a certificate, you have to add the TrustServerCertificate property and set it to 'True' to avoid errors.

Oracle

Using TNS-names entry

Data Source=TNSname;User ID=username;Password=password;

Without using TNS-names entry

Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=serverAddress)(PORT=port))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=serviceName)));User ID=username;Password=password;

OLE DB

Windows authentication

Provider=sqloledb;Data Source=_serverAddress_;Initial Catalog=_databaseName_;Integrated Security=SSPI;

No Windows authentication

Provider=sqloledb;Data Source=_serverAddress_;Initial Catalog=_databaseName_;Integrated Security=;User ID=_username_;Password=_password_;

ODBC

Microsoft Access database

Driver={Microsoft Access Driver (\*.mdb)};DBQ=_databaseFilePath_;

System Data Source Name, Windows authentication DSN=_dataSourceName_;Trusted\_Connection=Yes;
System Data Source Name, no Windows authentication DSN=_dataSourceName_;Uid=_username_;Pwd=_Password_;