Whether you prefer to use Open Table or Query Builder in JMP®, you may encounter the error: "The specified DSN contains an architecture mismatch between the Driver and Application" (Figure 1.1).
Figure 1.1
With Database Management Systems (DBMS) such as Oracle, MS SQL Server, PostgreSQL, etc., you need to configure the ODBC Data Source that corresponds with the architecture of JMP. Meaning, if you have 64-bit JMP, you configure your data source under the ODBC Data Source (64-bit). If you have 32-bit JMP, you configure your data source under the ODBC Data Source (32-bit). Figure 1:2 provides a layout as to how the Operating System, JMP, and ODBC driver source correlate when considering their architecture (Figure 1:2).
Figure 1:2
| Operating System | JMP | ODBC Source | File Location |
| 64-bit Windows | 64-bit JMP | 64-bit ODBC | c:\Windows\System32\odbcad32.exe |
| 64-bit Windows | 32-bit JMP | 32-bit ODBC | c:\Windows\SysWOW64\odbcad32.exe |
| 32-bit Windows | JMP (32-bit only) | ODBC (32-bit only) | c:\Windows\System32\odbcad32.exe |
Fixing the error would mean configuring an ODBC source that matches the architecture of JMP as shown in Figure 1:2 above. Please consult your IT Administrator for help obtaining a 32-bit or 64-bit driver for your database management system, that matches the architecture of JMP so you can avoid this error using Open Table or Query Builder.
[Previously JMP Note 64866]