Does database command work with windows 7 64 bit.

I could not establish a connection with Access 2010 database after defining the DSN using the Data source Source administrator.

note: I used the 32 bit version of the odbc administrator. The 64 on does not have odbc drivers defined.

[Kaustubha Govind]

Not sure if this configuration (mixing 64-bit machine with 32-bit ODBC drivers) is supported with MATLAB. Is your MATLAB 64-bit or 32-bit? If 64-bit, you should probably try the 32-bit version and see if it works.

[SAEED ALGHAMDI]

my win7 is 64 and my mat is 64. my access is 2010 (32 bit).

The only way to establish a data source is to use the 32-version of odbc administrator.

[Kaustubha Govind]

Did you try installing 32-bit MATLAB and connect with that?

Answer 1

[Chirag Gupta]

If you have 64 bit MATLAB then you should use 64 bit ODBC drivers (which I think Office 2010 provides).

[SAEED ALGHAMDI]

my office is (32 bit) using office 64 is not recommended by Microsoft yet.

[Chirag Gupta]

I agree with Kaustubha's suggestion. 32 bit MATLAB should be able to communicate with 32 bit ODBC admin.