odbc_databaseGetCatalogNames()

Synopsis

Returns a list of the database catalog names. Not all DBMS provide support for catalogs. Catalogs may contain one or more schemas.

Syntax

odbc_databaseGetCatalogNames ( db_pointer As User, _
                               Optional ignoreErrors? As Boolean = False ) As List 
Argument Type Description
db_pointer user Database reference. This reference should be obtained with the previous call to odbc_databaseOpen
ignoreErrors? boolean Optional; if the argument is True , then database errors are not reported as Intent exceptions; default is False .

Example 1

Enumerate database catalogs

Dim db As User = odbc_databaseOpen( "ODBC;DSN=PEFRESULTS")
		Dim catalogues As List = odbc_databaseGetCatalogNames( db) 
		odbc_databaseClose( db) 
		Return catalogues
 
		--> {"C:\My Documents\TestDatabase.accdb"}