error connecting matlab to Microsoft access

5 views (last 30 days)
joseph Frank
joseph Frank on 25 Feb 2011
Answered: arushi on 14 Aug 2024
Hi,
I am using teh followng files to connect matlab to access : http://www.mathworks.com/matlabcentral/fileexchange/29615-adodbtools
However I am receiving an error : ???Invoke Error, Dispatch Exception: Source:ADODB.Connection help file:C:\\Windows\HELP\ADO270.CHM help Context ID:12ee4f
I am using matlab 2010a and the access file is mdb (2003 database) Any help is greatly appreciated

Answers (1)

arushi
arushi on 14 Aug 2024
Hi Joseph,
It seems that you're encountering an error when trying to connect to an Access database using the ADODBTools package in MATLAB. This error can be caused by several issues, including problems with the ActiveX Data Objects (ADO) library, compatibility issues between the versions of MATLAB and Access, or issues with the database file itself.Here are some steps you can take to troubleshoot and resolve the issue:
1. Verify ADO Library Installation
Ensure that the ADO library is correctly installed on your system. You can do this by checking the version of the ADO library and making sure it's registered correctly.
2. Check MATLAB and Access Compatibility
Ensure that the versions of MATLAB and Access you are using are compatible. MATLAB 2010a is quite old, and there might be compatibility issues with newer versions of Access. Since you are using an Access 2003 database file, this should generally be compatible, but it's worth checking.
3. Use the Correct Connection String
Make sure you are using the correct connection string for your Access database.
4. Check File Permissions
Ensure that the Access database file has the correct permissions and is not being used by another application.
5. Update Drivers
Ensure that you have the latest Microsoft Access Database Engine drivers installed. You can download these from the Microsoft website. Make sure to install the drivers that match the bitness (32-bit or 64-bit) of your MATLAB installation.
Hope this helps.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!