Published by exdone
Posted on November 07, 2011
Full error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
Server: Windows 2k8 64bit
SQL Server : SQL 2k8 R2
Summary: This is occurring because you are trying to connect to a 64bit system. Notice that PHP runs in 32bit mode so you will need to set a 32bit DSN
run the following command to setup a 32bit DSN
C:\Windows\SysWOW64\odbcad32.exe
http://support.microsoft.com/kb/942976