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.

A typical form looks like this:

Once you have set up a connection to your database, you can create and execute your own SQL queries. Go here for details on SQL Editor.

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

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 f ODBC 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;

PostgreSQL

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

SQLite

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

Links

Connection strings

ODBC