Ask Your Question
1

MySQL ODBC driver problem [closed]

asked 2012-12-25 23:23:40 +0200

Charlesandpatricia gravatar image

updated 2016-02-18 17:18:44 +0200

Alex Kemp gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 17:19:20.741125

Comments

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

Charlesandpatricia gravatar imageCharlesandpatricia ( 2012-12-29 19:54:20 +0200 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2014-01-18 18:33:46 +0200

Alex Thurgood gravatar image

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

edit flag offensive delete link more
0

answered 2013-01-05 11:34:08 +0200

Charlesandpatricia gravatar image

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.

edit flag offensive delete link more
0

answered 2012-12-26 09:09:05 +0200

JohnSUN gravatar image

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)

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2012-12-25 23:23:40 +0200

Seen: 1,731 times

Last updated: Jan 18 '14