Get information about an ODBC, OLEDB or CUSTOM connection by using the GetDatabaseInfo method.
Example
The handle of the request is 1 because the applies at the app level.
The identifier of the connection is provided in input.
The client sends:
{
"jsonrpc": "2.0",
"id": 3,
"method": "GetDatabaseInfo",
"handle": 1,
"params": [
"EFC0A70A-F6C9CAEA-C5727CC9-2CBB8A41-A5470C6E"
]
}
The engine returns:
{
"jsonrpc": "2.0",
"id": 3,
"result": {
"qInfo": {
"qDBMSName": "Microsoft SQL Server",
"qDBUsage": true,
"qOwnerUsage": true,
"qDBSeparator": ".",
"qOwnerSeparator": ".",
"qDBFirst": true,
"qQuotePreffix": "\"",
"qQuoteSuffix": "\"",
"qSpecialChars": "#$ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûüýþÿ½§!\"@#£¤`$%&/{}[]()=?\\´/+-*><|;,:.-_^~¨*' \t",
"qDefaultDatabase": "LinkedTablesData",
"qKeywords": [
"BREAK",
"BROWSE",
"BULK",
"CHECKPOINT",
"CLUSTERED",
"COMMITTED",
"COMPUTE",
"CONFIRM",
"CONTROLROW",
"DATABASE",
"DBCC",
"DISK",
"DISTRIBUTED",
"DUMMY",
"DUMP",
"ERRLVL",
"ERROREXIT",
"EXIT",
"FILE",
"FILLFACTOR",
"FLOPPY",
"HOLDLOCK",
"IDENTITY_INSERT",
"IDENTITYCOL",
"IF",
"KILL",
"LINENO",
"LOAD",
"MIRROREXIT",
...
"USAGE",
"USER",
"USING",
"VALUE",
"VALUES",
"VARCHAR",
"VARYING",
"VIEW",
"WHEN",
"WHENEVER",
"WHERE",
"WITH",
"WORK",
"WRITE",
"YEAR",
"ZONE"
]
}
}
}
Information about the ODBC connection is displayed.