Returns a list of the database catalog names. Not all DBMS provide support for catalogs. Catalogs may contain one or more schemas.
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 . |
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"}