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.

<box-inline>Connection Editor</box-inline> menu

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

<box-inline>Connection Editor</box-inline>

Go here for details on SQL Editor.


Examples

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;


Examples of connections to databases on cloud servers

Note: The DSN property is not used when connecting to a database on a cloud server.

MySQL

Uid=root;Pwd= password;Driver={MySQL ODBC 8.0 ANSI Driver};Server=localhost;Database=myDatabase;

mySQL

PostgreSQL

Uid=postgres;Pwd=password;Driver={PostgreSQL ANSI(x64)};Server=localhost;Database=myDatabase;

postgres

SQLite

Driver={SQLite3 ODBC Driver};Database=F:\myDatabase.db;

SQLite


Connection strings

ODBC