Q: When trying to connect the client to the server, there is an error message with "Architecture mismatch".

A: An error message with "Architecture mismatch" means the 64 bit ODBC tool was used instead of the 32 bit tool to create the ODBC connection. Use the 32-bit tool. Pre 2012 servers need to go to C:\Windows\SysWow64\odbcad32.exe and use that to create the ODBC.

Tags: database connection, connect to database, ODBC connection, connect to server, server connection.