Allow Metadata From Multiple Catalogs

Key Name Default Value Required

AllowMetadataFrom
MultipleCatalogs

Enabled (1)

No

Description

This option specifies whether metadata is retrieved from all catalogs when the connector makes a call to SQLTables or SQLColumns.

  • Enabled (1): The connector retrieves metadata from all catalogs when making calls to SQLTables or SQLColumns, as per the ODBC standard.
  • Disabled (0): The connector only retrieves metadata from the specified catalog when making calls to SQLTables or SQLColumns.

Note:

  • If this option is disabled, you must specify a catalog to make calls to SQLTables or SQLColumns. You can specify a catalog in the call to SQLTables or SQLColumns, or in the Catalog DSN setting (the Catalog connection property).
  • Disabling this option may improve connector performance.