This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.


Return names of ODBC and JDBC data sources on system


d = getdatasources


d = getdatasources returns the names of valid ODBC and JDBC data sources on the system as a cell array d of character vectors. The function gets the names of ODBC data sources from the ODBC.INI file located in the folder returned by running:

myODBCdir = getenv('WINDIR')

d is empty when the ODBC.INI file is valid, but no data sources are defined. d equals -1 when the ODBC.INI file cannot be opened.

The function also retrieves the names of data sources that are in the system registry but not in the ODBC.INI file.

If you do not have write access to myODBCdir, the results of getdatasources may not include data sources that you recently added. In this case, specify a temporary, writable, output folder via the preference TempDirForRegistryOutput. For details about this preference, see setdbprefs.

getdatasources gets the names of JDBC data sources from the file that you define using setdbprefs or the Define JDBC data sources dialog box.


Get the names of databases on your system.

d = getdatasources
d = 
    'MS Access Database'  'dbtoolboxdemo'

Introduced before R2006a

Was this topic helpful?