Airstud
Topic Author
Posts: 3376
Joined: Wed Nov 29, 2000 11:57 am

ODBC Driver architecture mismatch thread

Fri May 19, 2017 8:12 am

We are long overdue for a thread on how to handle a SQL error IM014 that arises when Microsoft's ODBC Driver Manager reports that a specified DSN contains an architecture mismatch between the driver and the application.

(I mean we were ALL thinking it...)


See, I have set up a little MySQL database (I'm running MySQL Server 5.7) on my HP EliteBook 6930p laptop which runs Windows 7 Home Premium , Service Pack 1, 64 bit.

I want I should be able to access this database from within OpenOffice.org (fight the power of Microsoft! :grin:) so I have the MySQL ODBC connector installed and I used the Data Sources ODBC administrator tool in Control Panel to create a User DSN pointing to the MySQL database I wanted, that all went well.

Then I followed the instructions at https://wiki.openoffice.org/wiki/Connec ... on_Windows
for creating new "Base" file that connects to an existing database, and blame it, it was going so well... Base even found the database I wanted and said "Connection successful." But when it came time to finalize user authentication (which worked fine, with the exact same user credentials, when I was setting up the User DSN in Control Panel), I got that "specified DSN contains an architecture mismatch between the Driver and the Application." :boggled:

Googling has taken me to a half dozen websites that all say this problem arises when you use a 32-bit ODBC driver to connect to a 64-bit system. So from my Start menu I did a search for any files that have "odbc" in their names; it turned up three results

mysql-connector-odbc-5.1.13-win64 (1)
mysql-connector-odbc-5.1.13-win64
mysql-connector-odbc-5.3.7-win64

Also I went back to the ODBC Data Sources tool and noodled around for "Details" or "Advanced" settings where you could specify 32-bitness or 64-bitness; but found no such options.

So how is a 32-bit ODBC driver anywhere in the picture here? :boggled:

Anyway... much appreciatitude if anyone can shed some light on this.



And, as always:

:boggled:
Pancakes are delicious.
 
vrbarreto
Posts: 199
Joined: Thu Jun 16, 2016 8:22 am

Re: ODBC Driver architecture mismatch thread

Fri May 19, 2017 9:30 am

Have you tried turning it off and back on again? :D
 
Airstud
Topic Author
Posts: 3376
Joined: Wed Nov 29, 2000 11:57 am

Re: ODBC Driver architecture mismatch thread

Fri May 19, 2017 9:45 am

vrbarreto wrote:
Have you tried turning it off and back on again? :D


Thanks Roy.
Pancakes are delicious.
 
vrbarreto
Posts: 199
Joined: Thu Jun 16, 2016 8:22 am

Re: ODBC Driver architecture mismatch thread

Fri May 19, 2017 10:18 am

Airstud wrote:
vrbarreto wrote:
Have you tried turning it off and back on again? :D


Thanks Roy.


Pleasure.

There might be something in here that helps you

http://www.itgo.me/a/x50260285088327517 ... -and-appli

I understand there is no 64bit version of OpenOffice?

LibreOffice 64 bit is available

https://www.libreoffice.org/download/download/

Perhaps try that?

Who is online

Users browsing this forum: BobPatterson, treetreeseven and 3 guests

Popular Searches On Airliners.net

Top Photos of Last:   24 Hours  •  48 Hours  •  7 Days  •  30 Days  •  180 Days  •  365 Days  •  All Time

Military Aircraft Every type from fighters to helicopters from air forces around the globe

Classic Airliners Props and jets from the good old days

Flight Decks Views from inside the cockpit

Aircraft Cabins Passenger cabin shots showing seat arrangements as well as cargo aircraft interior

Cargo Aircraft Pictures of great freighter aircraft

Government Aircraft Aircraft flying government officials

Helicopters Our large helicopter section. Both military and civil versions

Blimps / Airships Everything from the Goodyear blimp to the Zeppelin

Night Photos Beautiful shots taken while the sun is below the horizon

Accidents Accident, incident and crash related photos

Air to Air Photos taken by airborne photographers of airborne aircraft

Special Paint Schemes Aircraft painted in beautiful and original liveries

Airport Overviews Airport overviews from the air or ground

Tails and Winglets Tail and Winglet closeups with beautiful airline logos