Database Connectivity

How I can access the Oracle and MS Access in matlab code, without using the ODBC connection?

Answer 1

[Titus Edelhofer]

The database toolbox also allows for using the JDBC connection, i.e., using a jdbc driver...

Titus

[Mohsin]

Hi,

My Question was, if we don't use the ODBC or JDBC at all, just like in ADO, we can connect to ORACLE or SQL Server, without using these ODBC informations.

The purpose of asking this question is if you distribute the executable to a computer, which doesn't have these ODBC settings, that there our m file or executable will not work.

[Titus Edelhofer]

Hi,

yes, there are other ways to connect. Nice thing about jdbc is, that you don't have to "prepare" the other computer, you can easily add the jdbc driver to your executable (lower part of "deploytool") and just run the program. No need to add some odbc setting.

Titus