ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

Hi Friends, recently i am working with MySQL, i have to set up DSN(data source name) to  access MySQL from Microsoft SQL Server.But ended up with following error: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

Google about this error and i got to know about the reason: this error comes when try to connect with MySQL 32-bit driver under 64-bit platform.

To overcome this issue firstly we have to download MySQL 32 bit Connector from hereInstall it and run following command (c:\windows\system32\odbcad32.exe) to configure DSN.

1. Once you run above command a pop up will come, Click on Add button.

How to Configure DSN

2. On next window, select a driver for which you want to set up data source.(Mysql odbc 3.51 Driver). Click on Finish.

3. Now Give your Data Source name, provide username, password and port. Choose Database.Click on Test.Click OK.

DSN IN windows 7

You are done, now connect to this DSN to remove above error.

2 thoughts on “ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

  1. ?????-????? ?????? ????????

    5 star article brilliant. I am new to blogging and you used a langauge I can understand

Comments are closed.