# 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.

{% hint style="info" %}
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.
  {% endhint %}

A typical form looks like this:

<figure><img src="/files/geBDfDihecmJFRlLzTlN" alt="Connection Editor"><figcaption></figcaption></figure>

Once you have set up a connection to your database, you can create and execute your own SQL queries. Go [here](/reference/plugins/database/shared-properties/sql-editor.md) 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`

{% hint style="info" %}
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.

<img src="/files/VzAXcPzSY7yDlnP9YtCc" alt="" data-size="original">
{% endhint %}

### 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;`

<figure><img src="/files/5p8EEReL7D1lITqHpZ8u" alt="mySQL"><figcaption></figcaption></figure>

### PostgreSQL

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

<figure><img src="/files/rCt0NfpBPQQAvWlhn6LP" alt="postgres"><figcaption></figcaption></figure>

### SQLite

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

<figure><img src="/files/qiK4Pg47y6YBwUCDY0Af" alt="SQLite"><figcaption></figcaption></figure>

***

## Links

**Connection strings**

* [Wikipedia: Connection string](http://en.wikipedia.org/wiki/Connection_string)
* [The Connection Strings Reference](http://www.connectionstrings.com/)

**ODBC**

* [Wikipedia: ODBC](http://en.wikipedia.org/wiki/Open_Database_Connectivity)
* [MSDN: ODBC connection string](https://msdn.microsoft.com/en-us/library/windows/desktop/ms722656\(v=vs.85\).aspx)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.linx.software/reference/plugins/database/shared-properties/connectioneditor.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.