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.
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 here. Install 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.
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.
You are done, now connect to this DSN to remove above error.