Cannot see ODBC connections on 64 bit laptop

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.

I've searched around and seen various versions of this problem come up a lot, but the suggestions haven't worked for me. A few months ago this question was posted: http://www.mathworks.com/matlabcentral/answers/8208-does-database-command-work-with-windows-7-64-bit

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

Michael

This issue has come up a few times

Answer 1

[Walter Roberson]

Yes, you can install both the 32 bit and 64 bit version of MATLAB on the same computer. One of the two will have all the file association to .m and related files at any one time, but that is probably not a substantial problem.

I would suggest that it is probably faster to install the 32 bit version and test out your code in that, than it is to try to debug the 64 bit version further. No point proceeding further until you have isolated the problem on a configuration known to work.