Thursday, March 29, 2012

How to solve "The specified DSN contains an architecture mismatch between the Driver and Application"?

This error happen on  Classic asp on IIS 7 with window 7 64 bit for MS Access database.

Change the "Advanced Settings" on your Application Pool to "Enable 32-bit applications" = True


Reference:
http://social.technet.microsoft.com/Forums/en/w7itproinstall/thread/02bbfb17-d892-49a3-b1f6-75c2533a18a1

How to set up ODBC system DSN on Windows 7?

in command line run:
C:\Windows\SysWOW64\odbcad32.exe

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

How to run & debug classic ASP in Visual Studio 2010 with IIS 7 on Windows 7

http://www.falconwebtech.com/post/2010/12/28/Debugging-Classic-ASP-in-IIS7-and-VS2010.aspx
Windows Features