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

mysql vb.net dataset crystal-reports-2008
bolek evora picture bolek evora · Jan 28, 2014 · Viewed 47.2k times · Source

how can i fix this error? ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.. it is occuring in a new project that i am doing... im using vb 2008 , MYSQL as my database and windows 8.1 as my OS

i read on forums that you just fix with the odbc administrator tool... i tried creating my DSN there but it still doesnt work... i tried opening an old project of mine it works fine.. but this new project keeps getting that error.. i need this to work so that i can do my crystal reports.. i've been trying to fix this error for a full day now and i cant fix it..

can someone help me? THANKS..

Answer

user2990854 picture user2990854 · Jan 28, 2014

its a 64 vs 32 bit issue. You are accessing a 32 bit odbc driver on a 64 bit system.

IF YOU OPEN c:\windows\system32\odbcad32.exe you will not see a driver there that is in c:\windows\syswow64\odbcad32.exe (or just the opposite)

Check the target platform of your application, and if that doesn't fix it, you might be able to sneak by just installing the correct driver ( 64 or 32 bit )

Related questions

How To assign null values in MySql using VB.NET

I am not sure why VB makes everything such a pain. I have a fields which stores the date and time in the format required to store in MySQL database Dim AppDate As String = String.Empty If Not String.IsNullOrEmpty(…

Read More
How to convert fingerprint to unique id to use it for searching in database?

I have fingerprint reader secugen and I have been able to get my application to control the fingerprint device by scanning fingerprints and I have been able to save them to mysql database! After saving the fingerprints to the db, …

Read More
passing an Array as a Parameter to be used in a SQL Query using the "IN" Command

Good Afternoon to All, I have a question concerning on SQL Queries. is it possible to use an array as a parameter to a query using the "IN" command? for example, int x = {2,3,4,5} UPDATE 'table_name' set 'field' = data WHERE …

Read More