# List the ODBC connections

List the ODBC connections available in the system by using the [GetOdbcDsns method](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/EngineJSONAPI/Content/service-global-getodbcdsns.htm).

## Example

[](https://help.qlik.com/en-US/sense-developer/Subsystems/EngineAPI/Content/Sense_EngineAPI/CreatingAppLoadingData/ConnectToDataSources/list-ODBC-connections.htm)

#### The goal is to list the ODBC connections available in the system.

The handle of the request is -1 because the [GetOdbcDsns method](https://help.qlik.com/en-US/sense-developer/May2025/Subsystems/EngineJSONAPI/Content/service-global-getodbcdsns.htm) applies at global level.

The client sends:

```
{
  "jsonrpc": "2.0",
  "id": 0,
  "method": "GetOdbcDsns",
  "handle": -1,
  "params": []
}
```

The engine returns:

```
{
  "jsonrpc": "2.0",
  "id": 0,
  "result": {
    "qOdbcDsns": [
      {
        "qName": "ProductDay",
        "qDescription": "SQL Server"
      },
      {
        "qName": "ProductDay2",
        "qDescription": "SQL Server"
      },
      {
        "qName": "qasql2008",
        "qDescription": "SQL Server"
      },
      {
        "qName": "qasql2008_intetest",
        "qDescription": "SQL Server"
      },
      {
        "qName": "qasql2008_NativeClient_tester",
        "qDescription": "SQL Server Native Client 11.0"
      },
      {
        "qName": "qasql_intetest",
        "qDescription": "SQL Server"
      },
      {
        "qName": "dBASE Files",
        "qDescription": "Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)",
        "qUserOnly": true
      },
      {
        "qName": "Excel Files",
        "qDescription": "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)",
        "qUserOnly": true
      },
      {
        "qName": "MS Access Database",
        "qDescription": "Microsoft Access Driver (*.mdb, *.accdb)",
        "qUserOnly": true
      },
      {
        "qName": "Visio Database Samples",
        "qDescription": "Microsoft Access Driver (*.mdb, *.accdb)",
        "qUserOnly": true
      }
    ]
  }
}
```

The list of the ODBC connections is returned.