Very simple!
On server:
SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQL
Delete the USER data source name and define it as a SYSTEM data source name. Go to -> Start -> Settings -> Control Panel -> Administrative Tools -> Data Sources (ODBC): – User DSN : delete the specified User DSN – System DSN : create a new System DSN
Else try to install same 32bits or 64bits version as locally installed.
Locally:
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
32bit/64 bit conflict – either you install a 32bit driver version or you use/configure the 32bit under C:\Windows\SysWoW64\
Try to install same 32bits or 64bits version as locally installed.