Desktop Client: Microsoft ODBC Driver Manager Architecture Mismatch Error when importing Database Data on a 64-bit System
iGrafx applications, all 32-bit, will work on computers running 64-bit versions of Windows without any changes.
However, if your ODBC connections have been created by the (default) 64-bit ODBC connection manager, you may get this error when trying to import data from a database (Tools > Import Database):
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and the Application
This is because the use of the 64-bit ODBC driver is not compatible with the iGrafx 32-bit application. The 64-bit version was likely configured because you have 64-bit Windows, and the 64-bit Microsoft Office applications installed.
You may also get the following type of error:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
To solve this you should create, and then use, a connection to the database with the 32-bit ODBC connection manager you find here: C:\Windows\SysWOW64\odbcad32.exe (you may also be able to access the ODBC drivers from 'Administrative Tools' in the Control Panel.
Steps similar to the following can be tried to create the ODBC connection:
- Launch odbcad32.exe
- Add a User or System DSN
- Choose the Microsoft Excel Driver (*.xls)
- Click Finish
- Name the connection (e.g. Excel32bit)
- Click Ok to save changes and exit
Please see our 'System Requirements' pages for more information on which operating systems are supported for specific iGrafx products.