ERROR : The specified DSN contains anarchitecture mismatch between the Driver and Application

Question

. I try to connect my BI project in visual studio 2008 to mysql database. so I defined odbc connection in Start > Programs > Administrative Tools > Data Sources [win 7] and I tasted it, it connected successfully .

but when I want to open this connection in VS > "View" > "Server Explorer", I see this error:

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

even I put "root" as user name in the text box and pass empty [bc I didn`t set pass for my mysql db] , but nothing changed!!

Answer 1

I had a similar issue but with a console application in Visual Studio 2008. The project's Platform Target was set to "Any CPU" which defaulted to 64 bit, and when I tried to access data using a 32bit ODBC driver I got the error described by @afsane. My solution was to set the Platform Target to x86: