unable to establish database connection

2 views (last 30 days)
SAEED ALGHAMDI
SAEED ALGHAMDI on 3 Jun 2011
Hi I am using matlab 2011 64 bit on my win7 64 pc using office 2010 32 bit version. I try to connect to a access tutorial data base. I used odbc data source administration to add a data base source. I create a connection to this database using the database command. When I try the ping command to test the connection it tells me that " ??? Error using ==> database.ping at 153 Invalid connection. "
Note: win 7 64 has two odbs administrator 32 bit(C:\Windows\SysWOW64\odbcad32.exe) and 64 bit(%windir%\system32\odbcad32.exe) I used the 32 since the 64 are missing the required odbc drivers.
  2 Comments
Oleg Komarov
Oleg Komarov on 3 Jun 2011
I think you cannot do Matlab 64 to Office 32. Try jdbc connection.
Chirag Gupta
Chirag Gupta on 3 Jun 2011
I am pretty sure Access does not provide JDBC drivers! You have to use 32 bit Matlab to talk to 32 bit ODBC admin

Sign in to comment.

Answers (1)

Sean de Wolski
Sean de Wolski on 17 Sep 2012
Answered in comment.

Community Treasure Hunt

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

Start Hunting!