GetDatabaseInfo method

Overview

Gives information about an ODBC, OLEDB or CUSTOM connection. See Outputs for more details.

Name	Description	Type
qConnectionId	Name of the connection This parameter is mandatory.	String

Name

Description

Type

qConnectionId

Name of the connection

This parameter is mandatory.

String

The following is returned in the output:

Name	Description	Type
qInfo	Information about the connection	DatabaseInfo

Name	Description	Type
qDBMSName	Name of the product accessed by the provider	String
qDBUsage	If set to true, it means that the data source contains some databases.	Boolean
qOwnerUsage	If set to true, it means that the data source contains some owners.	Boolean
qDBSeparator	Character string used after the database name Example with separator ".": FROM LinkedTablesData.dbo.Months Where: LinkedTablesData is the database name dbo is the owner name Months is the table name	String
qOwnerSeparator	Character string used after the owner name Example with separator ".": FROM LinkedTablesData.dbo.Months Where: LinkedTablesData is the database name dbo is the owner name Months is the table name	String
qDBFirst	If set to true, it means that the database is displayed first, before the owners and tables.	Boolean
qQuotePreffix	Prefix used with field, database or owner names that contain special characters or keywords.	String
qQuoteSuffix	Suffix used with field, database or owner names that contain special characters or keywords.	String
qSpecialChars	List of the special characters	String
qDefaultDatabase	Name of the default database	String
qKeywords	List of the script keywords	Array of String

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!