Timeline for How can I connect to a database using the 32 Bit ODBC on a Windows 7 (64 Bit) machine?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 19, 2012 at 8:53 | vote | accept | gwr | ||
| Apr 18, 2012 at 14:31 | comment | added | gwr | In[160]:= conn = OpenSQLConnection[JDBC["odbc", "accessDatabase"]] (* where "accessDatabase" is a 32bit DSN *) During evaluation of In[160]:= JDBC::error: [Microsoft][ODBC Driver Manager] Der angegebene DSN weist eine nicht übereinstimmende Architektur von Treiber und Anwendung auf.>> (Translation: DSN does not have a compatible architecture with regard to the driver.) This is to reproduce the error; for further comments please refer to the Answer 1 where I have commented also. Thanks. | |
| Apr 18, 2012 at 14:15 | answer | added | WReach | timeline score: 9 | |
| Apr 18, 2012 at 10:58 | comment | added | Yves Klett | This may become messy. We had a related problem and only solved it by switching to a freshly setup 64bit machine. Can you delete the 32bit ODBC DSN and try with a new 64bit one? | |
| Apr 18, 2012 at 10:29 | comment | added | Verbeia | What error are you getting? | |
| Apr 18, 2012 at 10:28 | history | asked | gwr | CC BY-SA 3.0 |