How to add your knowledge
odbc_databaseGetCatalogNames()
Table of contents
- 1. Synopsis
- 2. Syntax
- 3. Example 1
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"}
Comments