Control Compliance Suite - MySQL External Data Integration - Error: The specified DSN contains an architecture mismatch between the Driver and Application.

Article:TECH199664  |  Created: 2012-11-13  |  Updated: 2012-11-13  |  Article URL http://www.symantec.com/docs/TECH199664
Article Type
Technical Solution


Issue



After configuring a MySQL External Data Integration connection - during the data collection, the CCS Manager reports an error: The specified DSN contains an architecture mismatch between the Driver and Application.

 


Error



Date,Message,Details,Category,Asset,Asset type,Asset owner,
12/11/2012 10:19:32,Job Exception Occurred,SQL query execution failed: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application,,,,,

 


Environment



Control Compliance Suite 10.x and 11.x

Windows 2003, 2008, 2008R2

MySQL

 


Cause



The architecture of the ODBC driver and DSN does not match the architecture of the Windows system.

 


Solution



If the data collection is done on a 64bit Windows system, make sure to install the 64bit MySQL ODBC drivers (mysql-connector-odbc-5.2.2-winx64.msi or similar) and configure the System DSN using the 64bit version of odbcad32.exe located in C:\Windows\System32, on that system.

If the data collection is done on a 32bit Windows system, make sure to install the 32bit MySQL ODBC drivers (mysql-connector-odbc-5.2.2-win32.msi or similar) and configure the System DSN using the 32bit version of odbcad32.exe located in C:\Windows\SysWOW64, on that system.

  As you're reading this article, you might also be interested in the following articles:

Control Compliance Suite - External Data Integration - creating a MySQL Data Location - http://www.symantec.com/docs/TECH199623

Control Compliance Suite - MySQL External Data Integration - Error: You have an error in your SQL syntax. - http://www.symantec.com/docs/TECH199666

 




Article URL http://www.symantec.com/docs/TECH199664


Terms of use for this information are found in Legal Notices