We replaced a server 2003 SQL 2005 32 bit with a server 2008 R2 SQL 2005 64 bit. Programs (using ODBC) updated on the new server run fine from the workstations (mostly Win 7 64 bit). The same ODBC definition is unable to see or connect to the new server from the workstations. An MS Access ADP is unable to run from the workstations; it runs fine on the new server. I have checked the SQL client drivers, comm protocols, and permissions.
The ODBC problem is Question 1 - separate.