Take the 2-minute tour ×
Mathematica Stack Exchange is a question and answer site for users of Mathematica. It's 100% free, no registration required.

Runnig this code after building the ODBC connection for my access application named WPC :

Needs["DatabaseLink`"];
OpenSQLConnection[JDBC["odbc", "WPC"]];

I get this message :

JDBC::error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application >>

I am using Microsoft Access 2010 (32 bit) and Windows 7 (64 bit) so I have built the ODBC with odbcad32.

Some one has an idea what is the problem/solution ?

share|improve this question
    
you can check this answer stackoverflow.com/questions/10289655/… –  s.s.o Jun 24 '13 at 9:54
    
Not a good combination. The whole 32bit Access and 64bit Windows + Mathematica thing is unpredictable AFAIK. On some machines it works, on some it does not (and even that changes from time to time for reasons unknown). –  Yves Klett Jun 24 '13 at 15:16

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.