'The specified DSN contains an architecture mismatch' Message Appearing

From HotDocs Wiki

Jump to: navigation, search

Problem

After installing HotDocs Template Portal on a 64-bit operating system, the following error message appears:

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

This error is encountered when the SystemDSN ODBC created for Template Portal is 64-bit instead of 32-bit.

Solution

Create a new 32-bit ODBC for HotDocs Template Portal:

  1. Ensure that the IIS Application Pool for Template Portal is enabled for 32-bit application. Open IIS and navigate to Application Pools > the Template Portal Application Pool > Advanced Settings.
  2. Check that the Enable 32-bit Applications setting is set to True.
  3. Run the 32-bit ODBC Data Source Administrator Tool. This is usually located in: C:\Windows\SysWOW64\odbcad32.exe
  4. Re-create the SystemDSN ODBC for Template Portal.
  5. Open the Web.config file for Template Portal. By default, this is located in C:\Program Files (x86)\HotDocs Server\Template Portal\ .
  6. Change the DSN value in <add key="DbConnection" value="DSN=***;UID=***;PWD=***"></add> the to the name of the new SystemDSN ODBC.
  7. Restart your browser and open Template Portal. It should now load correctly.