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 Connection Editor icon or dropdown list item.

Connection Editor menu

The Connection Editor helps build the connection string by offering the most common connection properties depending on the selected connection type.

Connection Editor

Samples

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

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;

Connection strings
ODBC