Hi everyone. I'm working on an application that accesses an MS Access database through an ODBC connection. Works fine on my 32-bit XP computer, but I'm having problems trying to get it working on a 64-bit Vista laptop. The 64-bit laptop has 64-bit Matlab 2009b installed. The 64-bit version of the ODBC Data Source Administrator does not allow me to create an MS Access source - doesn't have the drivers. So I have to create the source using the 32-bit version of the ODBC Data Source Administrator. I'm using 32-bit Access 2007.
When I run the getdatasources command, I get an empty matrix . So it can't see any of the sources I've set up.
Almost exactly my problem. One of the suggestions was to install 32-bit Matlab. Before I go to the trouble of trying to do this, I'm hoping that someone can tell me that this will actually work. Is it because the laptop is 64bit, or because my version of Access is 64bit?
Also, could someone tell me if I can install a 64-bit and a 32-bit version of Matlab on the same computer?
Thanks so much for everyone's help, and sorry for the long post
This issue has come up a few times