I’ve moved from a laptop with Win XP to a new one with Windows 7 (64 bit). I’ve sucessfully installed Libre Office 3.6.4.3 and MySQL 5.2 and migrated my databases sucessfully, (can open and edit with the command line) but I’m unable to establish ODBC connections using mysql-connector-odbc-5.2.2-winx64. The error is: [Microsoft][ODBC Driver Manager] The specified DSN contains an archiecture mismatch between the Driver and the Application. Does this make sense to anyone? What can be done about it? Charles.
Hi sergdankov. Thanks for the info, but running C:\Windows\SysWOW64\odbcad32.exe gives the same error message. I don’t see how that helps with the problem. Charles
It’s not there. And do not be… It elsewhere in the data source (ODBC) for 32-bit systems, which can be found here:
C:\Windows\SysWOW64\odbcad32.exe
(Thanks for sergdankov)
I’ve failed to sort out the ODBC problem, and instead used the direct MySQL connector at http://extensions.openoffice.org/en/project/mysql_connector. Thanks to
Willynux for the information in reply to a related question. Charles.
The problem is that Win 7 is 64bit, but can run 32 or 64bit. However, LO is 32bit, and thus requires a 32bit ODBC driver in order to communicate with your msyql server, but if your mysql server is 64bit (which you don’t say), you will have an architecture mismatch.
Either make sure everything is 32bit : ODBC, mysql server, LO (no choice there for the moment, I believe) or else be prepared to encounter problems. That, at least, has been my experience.
Alex