Why do I receive an error when I try to connect to an Oracle database on with the Database Toolbox 3.4 (R2007b)?

I use a 64-bit version of Windows and a 32-bit version of Oracle and MATLAB. I setup up the ODBC connection and when I run the test it works. When I try to connect to it with the Database Toolbox, I receive the following error:

ERROR: While doing connection=database(), I get an error message that says:
TNF: Not resolved connection, ora-12154

Answer 1

[MathWorks Support Team]

This is an issue with the ODBC driver provided with the Oracle database. A bug report from Oracle which describes the issue that you are experiencing is available at:

https://mykestin.wordpress.com/2008/02/22/ora-12154-or-ora-6413-running-32-bit-oracle-software-on-64-bit-windows-os/

The issue is caused by the path name of the client software. The 32-bit version of MATLAB is typically in "C:\Program Files (x86)\MATLAB". Due to a bug in the Oracle driver, the "(x86)" string in the path name is causing it to fail to connect. The work around is to change the installation directory of MATLAB and Oracle so that they do not contain any parentheses. There is a bug tracker link which you may be able to use to check the status of the bug report.