List the ODBC connections
List the ODBC connections available in the system by using the GetOdbcDsns method.
Example
The handle of the request is -1 because the GetOdbcDsns method 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.