unable to establish database connection

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 comentarios

Oleg Komarov
Oleg Komarov el 3 de Jun. de 2011
I think you cannot do Matlab 64 to Office 32. Try jdbc connection.
Chirag Gupta
Chirag Gupta el 3 de Jun. de 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

Iniciar sesión para comentar.

Respuestas (1)

Etiquetas

Preguntada:

el 3 de Jun. de 2011

Community Treasure Hunt

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

Start Hunting!

Translated by