MATLAB: Is it possible to use Database Toolbox 3.2 (R2006b) in 64-bit MATLAB to connect to a Microsoft Access database

64accessdatabaseDatabase ToolboxMATLABwin64

I would like to use Database Toolbox 3.2 (R2006b) in 64-bit MATLAB to connect to a Microsoft Access database. When I set up the ODBC data source in Windows, it displays in QUERYBUILDER. However, when I try to connect to the data source, I the following error message is displayed:

 "[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified"

Best Answer

It is not possible to connect to a Microsoft Access database which is a 32-bit application with 64-bit MATLAB. Due to a general limitation of ODBC drivers, 64-bit MATLAB (or any 64-bit application) cannot interact with 32-bit ODBC drivers.

There are two ways to work around this issue:

1. Install 32-bit MATLAB on your 64-bit machine, and have 32-bit MATLAB and Database Toolbox communicate with the Microsoft Access Database.

If you need to work in the 64-bit MATLAB environment only, install 32-bit MATLAB on your 64-bit machine as well. Use 64-bit MATLAB as a COM automation client and 32-bit MATLAB as a COM automation server, and have 32-bit MATLAB and Database Toolbox communicate with the Microsoft Access Database.

For more information on MATLAB support for COM, please visit the following web site:

 <http://www.mathworks.com/help/matlab/using-com-objects-in-matlab.html>

2. Use Microsoft Excel to communicate with the database, and then use any of the following options to transfer the retrieved data from Excel to MATLAB:

a. Use Excel Link

b. Start Excel as a COM Automation Server

c. Use XLSREAD

Excel Link:

 <http://www.mathworks.com/products/excellink/>

Excel as COM Automation Server:

 <http://www.mathworks.com/access/helpdesk/help/techdoc/matlab_external/bqdwu3j.html>

XLSREAD:

 <http://www.mathworks.com/access/helpdesk/help/techdoc/index.html?/access/helpdesk/help/techdoc/ref/xlsread.html>

Related Solutions

MATLAB: Does MATLAB return errors when connecting to SQL Server database using Database Toolbox 3.6 (R2009b) on a 64-bit Windows machine

In a 64-bit machine, there are two versions of ODBC drivers. I.e. the 32-bit version and the 64-bit version. So you have to setup the drivers in both places to make it work for both 32-bit and 64-bit applications. The driver that you setup by using control panel (Start - Admin Tools - Data Sources) is for controlling the 64-bit version. However, we need to setup the 32-bit driver since the installed MATLAB is a 32-bit application. To do this, run the following executable:

C:\Windows\SysWOW64\odbcad32.exe

MATLAB: Do I receive an ‘Invalid connection’ error message when trying to establish a Dynamic Database Source Name (DSN) Connection to Access within Database Toolbox 3.10 (R2011b)

The below example has been incorporated into the documentation in Release 2012b (R2012b). For previous releases, read below for any additional information:

This error occurs due an error in the URL syntax. To connect to an Access database which has an ACCDB file format, please use the following form instead:

url = [['jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DSN='';DBQ='] dbpath];

Best Answer

Related Solutions

MATLAB: Does MATLAB return errors when connecting to SQL Server database using Database Toolbox 3.6 (R2009b) on a 64-bit Windows machine

MATLAB: Do I receive an ‘Invalid connection’ error message when trying to establish a Dynamic Database Source Name (DSN) Connection to Access within Database Toolbox 3.10 (R2011b)

Related Question