troubleshooting Question

No 64bit ODBC Administrator driver for MS Access on Windows 2012 R2 Server

Avatar of Barry Lysy
Barry LysyFlag for Canada asked on
Microsoft AccessWindows OSWindows Server 2012
3 Comments1 Solution749 ViewsLast Modified:
The system i am using is Windows 2012  R2.  So when trying to create an ODBC DSN to a MS Access DB, and using 64bit ODBC Admin, there is no MS Access driver to select.  If I use ODBC 32 bit admin, there is a MS Access driver to select.  But after selecting that 32 bit MS Access driver, this error msg appears "Failed to connect to link .... [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application".  Is there an OBDC driver update for the 64bit Windows system that solves this issue?  I looked but couldn't find anything that said for Windows 2012 R2 system.  Any suggestions would be appreciated.  thanks.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros