MATLAB: Am I unable to access the ODBC database using the Database Toolbox with MATLAB under Microsoft Windows

datadatabaseDatabase Toolboxodbc.inisourceswindows

I have added my database in MS Windows using the Data Sources (ODBC) control panel but I am still unable to "see" my database from the Database Toolbox in MATLAB.

Best Answer

In order for the Database Toolbox to access an ODBC database under MS Windows, the database must be in the file odbc.ini in the Windows installation directory. In order to add the database to this file, you should use the Data Sources (ODBC) control panel. However, if you do not have write permissions to this file, the Data Sources (ODBC) control panel does not generate an error when you add the database. Therefore, ensure that you have write permissions to the file odbc.ini and that your database has an entry there.

Related Solutions

MATLAB: Is it possible to set up Windows Authentication for ODBC data sources

The ODBC connection should be created with the following property enabled:

 'Windows NT authentication using the network login ID'

MATLAB should now be able to connect to the datasource without specifying the username and password. However, empty strings will still need to be passed in as arguments corresponding to these fields:

conn=database('myDataSource',' ',' ');

MATLAB: How to specify the Database URL String in the DATABASE function of Database Toolbox 3.4(R2007b) to connect to a POSTGRESQL database

For a PostGreSQL database the driver and the URL specifications are as follows:

JDBC driver: org.postgresql.DriverDatabase
URL: jdbc:postgresql://masd/DatabaseName

Please note that the Database URL string needs to have the Database name "DatabaseName" appended at the end of it.

Best Answer

Related Solutions

MATLAB: Is it possible to set up Windows Authentication for ODBC data sources

MATLAB: How to specify the Database URL String in the DATABASE function of Database Toolbox 3.4(R2007b) to connect to a POSTGRESQL database

Related Question